APPS.PAY_US_JOB_WC_USAGES_PKG dependencies on PAY_JOB_WC_CODE_USAGES

Line 34: FROM pay_job_wc_code_usages

30: AND wcf.state_code = l_state_code; /* in this state */
31: --
32: CURSOR csr_records_exist(l_state_code VARCHAR2, l_business_group_id NUMBER) IS
33: SELECT 1
34: FROM pay_job_wc_code_usages
35: WHERE state_code = l_state_code
36: AND business_group_id = l_business_group_id;
37: --
38: BEGIN /* Main program */

Line 63: INSERT INTO pay_job_wc_code_usages

59: --
60: --
61: FOR cur_rec IN csr_jobs(l_business_group_id) LOOP
62: --
63: INSERT INTO pay_job_wc_code_usages
64: (state_code,
65: business_group_id,
66: job_id,
67: wc_code)