DBA Data[Home] [Help]

APPS.PER_SUC_BUS dependencies on PER_JOBS_VL

Line 377: FROM per_jobs_vl per

373: --
374: CURSOR c1
375: IS
376: SELECT NULL
377: FROM per_jobs_vl per
378: WHERE per.job_id = NVL (p_job_id, -1)
379: AND p_effective_date BETWEEN per.date_from AND NVL (date_to, TRUNC (SYSDATE));
380: --
381: BEGIN