DBA Data[Home] [Help]

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;