APPS.PAY_SE_WAGES_SALARIES dependencies on PER_JOBS

Line 292: per_jobs pj

288: IS
289: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
290: FROM
291: per_all_people_f papf,
292: per_jobs pj
293: WHERE person_id=csr_v_person_id --21257 --21233
294: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
295: csr_v_end_date>=EFFECTIVE_START_DATE
296: AND primary_flag='Y'

Line 306: per_jobs pj

302: decode(pj.JOB_INFORMATION1,'Y','M',null) job,paaf.employee_category,
303: payroll_id
304: FROM
305: per_all_assignments_f paaf,
306: per_jobs pj
307: WHERE person_id=csr_v_person_id --21197 --21257 --21233
308: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
309: csr_v_end_date >=paaf.EFFECTIVE_START_DATE
310: AND primary_flag='Y'

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

315:
316:
317: /*CURSOR csr_painter(csr_v_person_id NUMBER,csr_v_start_date date, csr_v_end_date date)
318: IS
319: /*SELECT JOB_INFORMATION1 FROM per_jobs pj, per_roles pr
320: WHERE pj.job_id=pr.job_id
321: AND pj.JOB_INFORMATION_CATEGORY='SE'
322: AND pr.person_id=csr_v_person_id; --21257 */
323: /*SELECT JOB_INFORMATION1,start_date, start_date+(e_date-start_date-1) end_date

Line 328: FROM per_jobs pj, per_roles pr

324: FROM
325: (
326: SELECT JOB_INFORMATION1,start_date,lead( start_date, 1, to_date('31-12-4713','dd-mm-yyyy') )
327: over (order by start_date ASC) e_date
328: FROM per_jobs pj, per_roles pr
329: WHERE pj.job_id=pr.job_id
330: AND pj.JOB_INFORMATION_CATEGORY='SE'
331: AND pr.person_id=csr_v_person_id /*21197*/--)
332: /*WHERE start_date<=csr_v_end_date --'31-dec-2005'

Line 798: per_jobs pj

794: IS
795: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
796: FROM
797: per_all_people_f papf,
798: per_jobs pj
799: WHERE person_id=csr_v_person_id --21257 --21233
800: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
801: csr_v_end_date>=EFFECTIVE_START_DATE
802: AND primary_flag='Y'

Line 812: per_jobs pj

808: decode(pj.JOB_INFORMATION1,'Y','M',null) job,paaf.employee_category,
809: payroll_id
810: FROM
811: per_all_assignments_f paaf,
812: per_jobs pj
813: WHERE person_id=csr_v_person_id --21197 --21257 --21233
814: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
815: csr_v_end_date >=paaf.EFFECTIVE_START_DATE
816: AND primary_flag='Y'

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

821:
822:
823: CURSOR csr_painter(csr_v_person_id NUMBER,csr_v_start_date date, csr_v_end_date date)
824: IS
825: /*SELECT JOB_INFORMATION1 FROM per_jobs pj, per_roles pr
826: WHERE pj.job_id=pr.job_id
827: AND pj.JOB_INFORMATION_CATEGORY='SE'
828: AND pr.person_id=csr_v_person_id; --21257 */
829: SELECT JOB_INFORMATION1,start_date, start_date+(e_date-start_date-1) end_date

Line 834: FROM per_jobs pj, per_roles pr

830: FROM
831: (
832: SELECT JOB_INFORMATION1,start_date,lead( start_date, 1, to_date('31-12-4713','dd-mm-yyyy') )
833: over (order by start_date ASC) e_date
834: FROM per_jobs pj, per_roles pr
835: WHERE pj.job_id=pr.job_id
836: AND pj.JOB_INFORMATION_CATEGORY='SE'
837: AND pr.person_id=csr_v_person_id /*21197*/)
838: WHERE start_date<=csr_v_end_date --'31-dec-2005'