APPS.HRWCDCR_PKG dependencies on PAY_WC_FUNDS

Line 19: SELECT PAY_WC_FUNDS_S.NEXTVAL

15: X_CALCULATION_METHOD3 VARCHAR2) IS
16: BEGIN
17: hr_utility.set_location('pywcdcr.insert_row', 0);
18: --
19: SELECT PAY_WC_FUNDS_S.NEXTVAL
20: INTO X_FUND_ID
21: FROM DUAL;
22: --
23: hr_utility.set_location('pywcdcr.insert_row', 1);

Line 31: INSERT INTO PAY_WC_FUNDS

27: END IF;
28: --
29: hr_utility.set_location('pywcdcr.insert_row', 2);
30: --
31: INSERT INTO PAY_WC_FUNDS
32: (FUND_ID, BUSINESS_GROUP_ID, CARRIER_ID, LOCATION_ID,
33: STATE_CODE, CALCULATION_METHOD, CALCULATION_METHOD2, CALCULATION_METHOD3)
34: VALUES
35: (X_FUND_ID, X_BUSINESS_GROUP_ID, X_CARRIER_ID, X_LOCATION_ID,

Line 42: FROM PAY_WC_FUNDS

38: hr_utility.set_location('pywcdcr.insert_row', 3);
39: --
40: SELECT ROWID
41: INTO X_ROWID
42: FROM PAY_WC_FUNDS
43: WHERE FUND_ID = X_FUND_ID;
44: --
45: hr_utility.set_location('pywcdcr.insert_row', 4);
46: --

Line 67: UPDATE PAY_WC_FUNDS

63: X_CALCULATION_METHOD3 VARCHAR2) IS
64: BEGIN
65: hr_utility.set_location('pywcdcr.update_row', 0);
66: --
67: UPDATE PAY_WC_FUNDS
68: SET FUND_ID = X_FUND_ID
69: , BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
70: , CARRIER_ID = X_CARRIER_ID
71: , LOCATION_ID = X_LOCATION_ID

Line 102: DELETE FROM PAY_WC_FUNDS

98: X_CALCULATION_METHOD3 VARCHAR2) IS
99: BEGIN
100: hr_utility.set_location('pywcdcr.delete_row', 0);
101: --
102: DELETE FROM PAY_WC_FUNDS
103: WHERE ROWID = X_ROWID;
104: --
105: hr_utility.set_location('pywcdcr.delete_row', 1);
106: --

Line 129: FROM PAY_WC_FUNDS

125: X_CALCULATION_METHOD3 VARCHAR2) IS
126: --
127: CURSOR C IS
128: SELECT *
129: FROM PAY_WC_FUNDS
130: WHERE ROWID = X_ROWID
131: FOR UPDATE OF FUND_ID NOWAIT;
132: --
133: RECINFO C%ROWTYPE;

Line 205: FROM PAY_WC_FUNDS

201: l_comb_exists VARCHAR2(2);
202: --
203: CURSOR DUP_REC IS
204: SELECT 'Y'
205: FROM PAY_WC_FUNDS
206: WHERE CARRIER_ID = P_CARRIER_ID
207: AND STATE_CODE = P_STATE_CODE
208: AND ((LOCATION_ID = P_LOCATION_ID
209: AND P_LOCATION_ID IS NOT NULL)

Line 416: FROM PAY_WC_FUNDS WCF

412: -- same WC code as the one about to be deleted
413: --
414: CURSOR SAME_CODE_EXISTS IS
415: SELECT 'Y'
416: FROM PAY_WC_FUNDS WCF
417: WHERE WCF.STATE_CODE = P_STATE_CODE
418: AND WCF.ROWID <> P_ROWID
419: AND EXISTS (
420: SELECT 1

Line 493: FROM PAY_WC_FUNDS WCF

489: AND SCF.ID_FLEX_NUM = IFS.ID_FLEX_NUM
490: AND IFS.ID_FLEX_STRUCTURE_NAME = 'GREs and other data'
491: AND NOT EXISTS (
492: SELECT 1
493: FROM PAY_WC_FUNDS WCF
494: WHERE WCF.CARRIER_ID = P_CARRIER_ID
495: AND WCF.STATE_CODE = P_STATE_CODE
496: AND WCF.ROWID <> P_ROWID
497: AND ((WCF.LOCATION_ID IS NULL)