|
SELECT j.emplid , j.empl_Rcd , c.pymt_dt , cp.pymt_dt ,e.JOBCODE_DESCR FROM PS_JOB j , ps_gp_calendar c , ps_GP_RUN_TYPE r , ps_gp_calendar cp , ps_GP_RUN_TYPE rp ,PS_JOB_CURR_VW1 E WHERE j.effdt = ( SELECT MAX(effdt) FROM PS_JOB WHERE emplid=j.emplid AND empl_Rcd=j.empl_Rcd AND effdt <= %CurrentDateIn ) AND j.effseq= ( SELECT MAX(effseq) FROM PS_JOB WHERE emplid=j.emplid AND empl_rcd=j.empl_rcd AND effdt =j.effdt ) AND c.gp_paygroup=j.gp_paygroup AND c.pymt_dt = ( SELECT MIN(pymt_dt) FROM ps_gp_Calendar WHERE gp_paygroup=c.gp_paygroup AND pymt_dt > ( SELECT MAX(cp1.pymt_dt) FROM ps_gp_calendar cp1 , ps_gp_run_type r1 , PS_GP_CAL_RUN_DTL d WHERE cp1.gp_paygroup = cp.gp_paygroup AND cp1.pymt_dt <= %CurrentDateIn AND cp1.run_type = r1.run_type AND r1.calc_type = 'P' AND d.gp_paygroup = cp1.gp_paygroup AND d.cal_final_ts IS NOT NULL AND d.cal_id =cp1.cal_id ) ) AND c.run_type =r.run_type AND r.calc_type ='P' AND rp.run_type = cp.run_type AND rp.calc_type='P' AND cp.gp_paygroup=j.gp_paygroup AND cp.pymt_dt = ( SELECT MAX(cp1.pymt_dt) FROM ps_gp_calendar cp1 , ps_gp_run_type r1 , PS_GP_CAL_RUN_DTL d WHERE cp1.gp_paygroup = cp.gp_paygroup AND cp1.pymt_dt <= %CurrentDateIn AND cp1.run_type = r1.run_type AND r1.calc_type = 'P' AND d.gp_paygroup = cp1.gp_paygroup AND d.cal_final_ts IS NOT NULL AND d.cal_id =cp1.cal_id ) AND j.emplid=e.emplid AND j.empl_rcd=e.empl_rcd
|
EMPLID