SQL Exec: Effective Dated Query

-
 SQLEXEC("Select A.JOBCODE from PS_JOB A WHERE A.EMPLID = :1 AND 
A.EFFDT = (select max(B.effdt) from PS_JOB B WHERE B.EMPLID = A.EMPLID 
AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT <=SYSDATE) AND 
A.EFFSEQ = (SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE 
C.EMPLID= A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND 
C.EFFDT = A.EFFDT)",&Emplid, &Jobcode);

Comments

Post a Comment

Popular posts from this blog

BI Publisher: If Condition with sub-string in rtf template

-
 <?xdofx:if substr(ACAD_PLAN,1,1) = 'C'  then 'Los Angeles City College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'H'  then 'Los Angeles Harbor College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'M'  then 'Los Angeles Mission College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'P'  then 'Pierce College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'S'  then 'Los Angeles Southwest College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'V'  then 'Los Angeles Valley College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'W'  then 'West Los Angeles College' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'T'  then 'LA Trade-Technical Colleg' end if?>  <?xdofx:if substr(ACAD_PLAN,1,1) = 'E'  then 'East Los Angeles College' end if?>;
Read more