APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_JOBS

Line 189: FROM per_assignments_f paf,per_jobs pjb

185:
186: /* Cursor for fetching the person's job */
187: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
188: SELECT pjb.name
189: FROM per_assignments_f paf,per_jobs pjb
190: WHERE paf.person_id = l_person_id
191: AND pjb.job_id = paf.job_id
192: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
193:

Line 1454: FROM per_jobs

1450:
1451: /* Cursor for fetching the job */
1452: CURSOR csr_p_job (l_job varchar2 ,l_date date) IS
1453: SELECT name
1454: FROM per_jobs
1455: WHERE job_id = l_job
1456: AND l_date between date_from and nvl(date_to, to_date('31-12-4712','dd-mm-yyyy'));
1457:
1458: /* Cursor for fetching person's Address */