APPS.PAY_SE_FORA dependencies on PER_ROLES

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

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

Line 350: FROM per_jobs pj, per_roles pr

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