DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on PER_JOBS

Line 200: FROM per_all_assignments_f paf,per_jobs pjb

196:
197: /* Cursor for fetching the person's job */
198: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
199: SELECT pjb.name
200: FROM per_all_assignments_f paf,per_jobs pjb
201: WHERE paf.person_id = l_person_id
202: AND pjb.job_id = paf.job_id
203: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
204: