DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_JOBS_VL

Line 1374: from per_jobs_vl

1370: cursor c_job_name(cp_job_id in number
1371: ,cp_effective_date in date
1372: ) is
1373: select name
1374: from per_jobs_vl
1375: where job_id = cp_job_id
1376: and date_from <= cp_effective_date
1377: and nvl(date_to, cp_effective_date) >= cp_effective_date
1378: order by date_from desc;