DBA Data[Home] [Help]

APPS.PAY_US_JOB_WC_USAGES_PKG dependencies on PER_JOBS

Line 21: FROM per_jobs

17: l_valid NUMBER := 0;
18: --
19: CURSOR csr_jobs( l_business_group_id NUMBER) IS
20: SELECT job_id
21: FROM per_jobs
22: WHERE business_group_id = l_business_group_id
23: ORDER BY name;
24: --
25: CURSOR csr_valid_job_code(p_job_code NUMBER, l_state_code VARCHAR2) IS