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 324: per_jobs pj , --new

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

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'