DBA Data[Home] [Help]

APPS.PAY_US_DB_PER_SETUP dependencies on PAY_WC_FUNDS

Line 2230: SELECT PAY_WC_FUNDS_S.NEXTVAL

2226: --
2227: hr_utility.trace('Entered insert_wc_fund');
2228: hr_utility.set_location('scltstdat.insert_wc_fund',1);
2229: --
2230: SELECT PAY_WC_FUNDS_S.NEXTVAL
2231: INTO l_fund_id
2232: FROM DUAL;
2233: --
2234: hr_utility.set_location('scltstdat.insert_wc_fund',5);

Line 2242: INSERT INTO PAY_WC_FUNDS

2238: END IF;
2239: --
2240: hr_utility.set_location('scltstdat.insert_wc_fund',10);
2241: --
2242: INSERT INTO PAY_WC_FUNDS
2243: (FUND_ID, BUSINESS_GROUP_ID, CARRIER_ID, LOCATION_ID, STATE_CODE)
2244: VALUES
2245: (L_FUND_ID, P_BUSINESS_GROUP_ID, P_CARRIER_ID, P_LOCATION_ID,
2246: P_STATE_CODE);