APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_TYPES

Line 1352: update /*+NO_INDEX*/ hr_s_balance_types

1348:
1349: update /*+NO_INDEX*/ hr_s_balance_categories_f
1350: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1351:
1352: update /*+NO_INDEX*/ hr_s_balance_types
1353: set BALANCE_CATEGORY_ID = BALANCE_CATEGORY_ID - 50000000;
1354:
1355: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1356:

Line 1456: update hr_s_balance_types

1452: update hr_s_balance_categories_f
1453: set balance_category_id = l_new_balance_category_id
1454: where balance_category_id = r_distinct.c_surrogate_key;
1455:
1456: update hr_s_balance_types
1457: set balance_category_id = l_new_balance_category_id
1458: where balance_category_id = r_distinct.c_surrogate_key;
1459:
1460: END update_uid;

Line 1738: from hr_s_balance_types;

1734: , base_balance_type_id
1735: , balance_category_id
1736: , rowid
1737: , new_balance_type_flag
1738: from hr_s_balance_types;
1739:
1740: CURSOR class (bal_type_id number)
1741: IS
1742: -- Cursor for installation of classification rules

Line 1819: from hr_s_balance_types;

1815: --with the delivered values
1816:
1817: select count(*)
1818: into cnt
1819: from hr_s_balance_types;
1820:
1821: If cnt=0 then return; end if;
1822:
1823:

Line 1829: from hr_s_balance_types b

1825: into l_null_return
1826: from pay_balance_types a
1827: where exists
1828: (select null
1829: from hr_s_balance_types b
1830: where a.balance_type_id = b.balance_type_id
1831: );
1832:
1833: --conflict may exist

Line 1842: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES

1838:
1839: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
1840: set balance_type_id = balance_type_id - 50000000;
1841:
1842: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1843: set balance_type_id = balance_type_id - 50000000;
1844:
1845: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1846: set base_balance_type_id = base_balance_type_id - 50000000;

Line 1845: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES

1841:
1842: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1843: set balance_type_id = balance_type_id - 50000000;
1844:
1845: update /*+NO_INDEX*/ hr_s_BALANCE_TYPES
1846: set base_balance_type_id = base_balance_type_id - 50000000;
1847:
1848: update /*+NO_INDEX*/ hr_s_DEFINED_BALANCES
1849: set balance_type_id = balance_type_id - 50000000;

Line 1893: from hr_s_balance_types;

1889: select min(balance_type_id) - (count(*) *3)
1890: , max(balance_type_id) + (count(*) *3)
1891: into v_min_delivered
1892: , v_max_delivered
1893: from hr_s_balance_types;
1894:
1895: select max(balance_type_id)
1896: into v_max_live
1897: from pay_balance_types;

Line 2013: update hr_s_balance_types

2009: END;
2010:
2011: -- Update all child entities
2012:
2013: update hr_s_balance_types
2014: set balance_type_id = l_new_surrogate_key
2015: where balance_type_id = stu_rec.c_surrogate_key;
2016:
2017: update hr_s_balance_types

Line 2017: update hr_s_balance_types

2013: update hr_s_balance_types
2014: set balance_type_id = l_new_surrogate_key
2015: where balance_type_id = stu_rec.c_surrogate_key;
2016:
2017: update hr_s_balance_types
2018: set base_balance_type_id = l_new_surrogate_key,
2019: new_balance_type_flag = v_new_balance_type_flag
2020: where base_balance_type_id = stu_rec.c_surrogate_key;
2021:

Line 2104: delete from hr_s_balance_types

2100:
2101: delete from hr_s_balance_feeds_f
2102: where balance_type_id = stu_Rec.c_surrogate_key;
2103:
2104: delete from hr_s_balance_types
2105: where rowid = stu_rec.rowid;
2106:
2107:
2108: END remove;

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

2636:
2637: --
2638: -- This statement removes any balance feeds from
2639: -- pay_balance_feeds_f that belong to a balance_type_id
2640: -- in hr_s_balance_types but do not exist in
2641: -- hr_s_balance_feeds_f.
2642:
2643: --PSEUDO
2644: if hr_legislation.g_pseudo_enabled = 'Y' THEN