APPS.PAY_SE_FORA dependencies on PER_ROLES

Line 340: /*SELECT JOB_INFORMATION1 FROM per_jobs pj, per_roles pr

336:
337:
338: CURSOR csr_painter(csr_v_person_id NUMBER,csr_v_start_date date, csr_v_end_date date)
339: IS
340: /*SELECT JOB_INFORMATION1 FROM per_jobs pj, per_roles pr
341: WHERE pj.job_id=pr.job_id
342: AND pj.JOB_INFORMATION_CATEGORY='SE'
343: AND pr.person_id=csr_v_person_id; --21257 */
344: SELECT JOB_INFORMATION1,start_date, start_date+(e_date-start_date-1) end_date

Line 349: FROM per_jobs pj, per_roles pr

345: FROM
346: (
347: SELECT JOB_INFORMATION1,start_date,lead( start_date, 1, to_date('31-12-4713','dd-mm-yyyy') )
348: over (order by start_date ASC) e_date
349: FROM per_jobs pj, per_roles pr
350: WHERE pj.job_id=pr.job_id
351: AND pj.JOB_INFORMATION_CATEGORY='SE'
352: AND pr.person_id=csr_v_person_id /*21197*/)
353: WHERE start_date<=csr_v_end_date --'31-dec-2005'