APPS.HRWCDCR_PKG dependencies on PAY_WC_RATES

Line 259: FROM PAY_WC_RATES

255: l_comb_exists VARCHAR2(2);
256: --
257: CURSOR DUP_REC IS
258: SELECT 'Y'
259: FROM PAY_WC_RATES
260: WHERE FUND_ID = P_FUND_ID
261: AND WC_CODE = P_WC_CODE
262: AND ((ROWID <> P_ROWID
263: AND P_ROWID IS NOT NULL)

Line 306: FROM PAY_WC_RATES

302: l_rec_exists VARCHAR2(2);
303: --
304: CURSOR REC_EXISTS IS
305: SELECT 'Y'
306: FROM PAY_WC_RATES
307: WHERE FUND_ID = P_FUND_ID;
308: --
309: --
310: BEGIN

Line 421: FROM PAY_WC_RATES WCR

417: WHERE WCF.STATE_CODE = P_STATE_CODE
418: AND WCF.ROWID <> P_ROWID
419: AND EXISTS (
420: SELECT 1
421: FROM PAY_WC_RATES WCR
422: WHERE WCR.FUND_ID = WCF.FUND_ID
423: AND WCR.WC_CODE = P_WC_CODE);
424: --
425: --