APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_TYPES

Line 1147: update /*+NO_INDEX*/ hr_s_balance_types

1143:
1144: update /*+NO_INDEX*/ hr_s_balance_categories_f
1145: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1146:
1147: update /*+NO_INDEX*/ hr_s_balance_types
1148: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1149:
1150: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1151:

Line 1251: update hr_s_balance_types

1247: update hr_s_balance_categories_f
1248: set balance_category_id = l_new_balance_category_id
1249: where balance_category_id = r_distinct.c_surrogate_key;
1250:
1251: update hr_s_balance_types
1252: set balance_category_id = l_new_balance_category_id
1253: where balance_category_id = r_distinct.c_surrogate_key;
1254:
1255: END update_uid;

Line 1533: from hr_s_balance_types;

1529: , base_balance_type_id
1530: , balance_category_id
1531: , rowid
1532: , new_balance_type_flag
1533: from hr_s_balance_types;
1534:
1535: CURSOR class (bal_type_id number)
1536: IS
1537: -- Cursor for installation of classification rules

Line 1614: from hr_s_balance_types;

1610: --with the delivered values
1611:
1612: select count(*)
1613: into cnt
1614: from hr_s_balance_types;
1615:
1616: If cnt=0 then return; end if;
1617:
1618:

Line 1624: from hr_s_balance_types b

1620: into l_null_return
1621: from pay_balance_types a
1622: where exists
1623: (select null
1624: from hr_s_balance_types b
1625: where a.balance_type_id = b.balance_type_id
1626: );
1627:
1628: --conflict may exist

Line 1637: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES

1633:
1634: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
1635: set balance_type_id = balance_type_id - 50000000;
1636:
1637: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1638: set balance_type_id = balance_type_id - 50000000;
1639:
1640: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1641: set base_balance_type_id = base_balance_type_id - 50000000;

Line 1640: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES

1636:
1637: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1638: set balance_type_id = balance_type_id - 50000000;
1639:
1640: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1641: set base_balance_type_id = base_balance_type_id - 50000000;
1642:
1643: update /*+NO_INDEX*/ hr_s_DEFINED_BALANCES
1644: set balance_type_id = balance_type_id - 50000000;

Line 1688: from hr_s_balance_types;

1684: select min(balance_type_id) - (count(*) *3)
1685: , max(balance_type_id) + (count(*) *3)
1686: into v_min_delivered
1687: , v_max_delivered
1688: from hr_s_balance_types;
1689:
1690: select max(balance_type_id)
1691: into v_max_live
1692: from pay_balance_types;

Line 1796: update hr_s_balance_types

1792: END;
1793:
1794: -- Update all child entities
1795:
1796: update hr_s_balance_types
1797: set balance_type_id = l_new_surrogate_key
1798: where balance_type_id = stu_rec.c_surrogate_key;
1799:
1800: update hr_s_balance_types

Line 1800: update hr_s_balance_types

1796: update hr_s_balance_types
1797: set balance_type_id = l_new_surrogate_key
1798: where balance_type_id = stu_rec.c_surrogate_key;
1799:
1800: update hr_s_balance_types
1801: set base_balance_type_id = l_new_surrogate_key,
1802: new_balance_type_flag = v_new_balance_type_flag
1803: where base_balance_type_id = stu_rec.c_surrogate_key;
1804:

Line 1887: delete from hr_s_balance_types

1883:
1884: delete from hr_s_balance_feeds_f
1885: where balance_type_id = stu_Rec.c_surrogate_key;
1886:
1887: delete from hr_s_balance_types
1888: where rowid = stu_rec.rowid;
1889:
1890:
1891: END remove;

Line 2413: -- in hr_s_balance_types but do not exist in

2409:
2410: --
2411: -- This statement removes any balance feeds from
2412: -- pay_balance_feeds_f that belong to a balance_type_id
2413: -- in hr_s_balance_types but do not exist in
2414: -- hr_s_balance_feeds_f.
2415:
2416: delete from pay_balance_feeds_f pbf
2417: where pbf.balance_type_id = stu_rec.c_surrogate_key