APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_JOBS

Line 174: FROM per_assignments_f paf,per_jobs pjb

170:
171: /* Cursor for fetching the person's job */
172: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
173: SELECT pjb.name
174: FROM per_assignments_f paf,per_jobs pjb
175: WHERE paf.person_id = l_person_id
176: AND pjb.job_id = paf.job_id
177: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
178:

Line 1396: FROM per_jobs

1392:
1393: /* Cursor for fetching the job */
1394: CURSOR csr_p_job (l_job varchar2 ,l_date date) IS
1395: SELECT name
1396: FROM per_jobs
1397: WHERE job_id = l_job
1398: AND l_date between date_from and nvl(date_to, to_date('31-12-4712','dd-mm-yyyy'));
1399:
1400: /* Cursor for fetching person's Address */