APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_JOBS

Line 285: FROM per_jobs_tl jbt

281: WHERE hrl.location_id = c_location_id;
282: --
283: CURSOR csr_job_name(c_job_id NUMBER) IS
284: SELECT jbt.name
285: FROM per_jobs_tl jbt
286: WHERE jbt.language = userenv('LANG')
287: AND jbt.job_id = c_job_id;
288: --
289: CURSOR csr_incl_excl(c_assignment_id NUMBER

Line 1234: FROM per_all_assignments_f paaf,per_jobs pj

1230: ,p_period_start_date DATE
1231: ,p_period_end_date DATE) RETURN NUMBER is
1232: CURSOR csr_job is
1233: SELECT paaf.effective_start_date,paaf.effective_end_date,pj.date_to
1234: FROM per_all_assignments_f paaf,per_jobs pj
1235: WHERE paaf.assignment_id=p_assignment_id
1236: AND paaf.business_group_id=p_business_group_id
1237: AND paaf.job_id=pj.job_id
1238: AND pj.job_information3='Y'