APPS.PAY_SE_FORA dependencies on PER_JOBS

Line 308: per_jobs pj

304: IS
305: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
306: FROM
307: per_all_people_f papf,
308: per_jobs pj
309: WHERE person_id=csr_v_person_id --21257 --21233
310: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
311: csr_v_end_date>=EFFECTIVE_START_DATE
312: AND primary_flag='Y'

Line 323: per_jobs pj , --new

319: payroll_id,
320: hsck.segment2 local_unit_id
321: FROM
322: per_all_assignments_f paaf,
323: per_jobs pj , --new
324: hr_soft_coding_keyflex hsck
325: WHERE assignment_id=csr_v_assignment_id --21197 --21257 --21233
326: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
327: csr_v_end_date >=paaf.EFFECTIVE_START_DATE

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'