APPS.PAY_EMP_ACTION_ARCH dependencies on PER_JOBS_VL
Line 1304: from per_jobs_vl
1300: cursor c_job_name(cp_job_id in number
1301: ,cp_effective_date in date
1302: ) is
1303: select name 1304: from per_jobs_vl 1305: where job_id = cp_job_id
1306: and date_from <= cp_effective_date
1307: and nvl(date_to, cp_effective_date) >= cp_effective_date
1308: order by date_from desc;