DBA Data[Home] [Help]

APPS.PAY_US_JOB_WC_USAGES_PKG dependencies on PAY_WC_RATES

Line 27: FROM pay_wc_funds wcf, pay_wc_rates wcr

23: ORDER BY name;
24: --
25: CURSOR csr_valid_job_code(p_job_code NUMBER, l_state_code VARCHAR2) IS
26: SELECT 1
27: FROM pay_wc_funds wcf, pay_wc_rates wcr
28: WHERE wcr.wc_code = p_job_code /* reference */
29: AND wcr.fund_id = wcf.fund_id /* for this fund */
30: AND wcf.state_code = l_state_code; /* in this state */
31: --