[Home] [Help]
1504: -- foreign keys that comprise the true key.
1505:
1506: l_null_return varchar2(1); -- For 'select null' statements
1507: l_new_surrogate_key number(15); -- New surrogate key for the delivery row
1508: l_bal_class_id pay_balance_classifications.balance_classification_id%type;
1509:
1510: CURSOR stu -- Selects all rows from startup entity
1511: IS
1512:
1541: from hr_s_balance_classifications hsbc
1542: where balance_type_id = bal_type_id
1543: and not exists
1544: ( select 1
1545: from pay_balance_classifications pbc
1546: where nvl(hsbc.business_group_id, -1) = nvl(pbc.business_group_id, -1)
1547: and hsbc.legislation_code = pbc.legislation_code
1548: and hsbc.balance_type_id = pbc.balance_type_id
1549: and hsbc.classification_id = pbc.classification_id
2201:
2202: IF v_payroll_install_status = 'I' THEN
2203:
2204:
2205: delete from pay_balance_classifications pbc
2206: where balance_type_id = stu_rec.c_surrogate_key
2207: and not exists
2208: ( select 1
2209: from hr_s_balance_classifications hsbc
2235:
2236: END;
2237:
2238: BEGIN
2239: insert into pay_balance_classifications
2240: (BALANCE_CLASSIFICATION_ID
2241: ,BUSINESS_GROUP_ID
2242: ,LEGISLATION_CODE
2243: ,BALANCE_TYPE_ID
2248: ,LAST_UPDATED_BY
2249: ,LAST_UPDATE_LOGIN
2250: ,CREATED_BY
2251: ,CREATION_DATE)
2252: select pay_balance_classifications_s.nextval
2253: , bal_classes.business_group_id
2254: , bal_classes.legislation_code
2255: , bal_classes.balance_type_id
2256: , bal_classes.classification_id
2282: --
2283: -- need to insert balance feeds to those existing elements that have the
2284: -- same classification as the balance classification just inserted.
2285: --
2286: select pay_balance_classifications_s.currval
2287: into l_bal_class_id
2288: from dual;
2289: --
2290: hr_balance_feeds.ins_bf_bal_class