eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_CLASSIFICATIONS

Line 1746: from hr_s_balance_classifications hsbc

1742: -- Cursor for installation of classification rules
1743: -- ADDED DISTINCT so that ldts that contains same bal_class
1744: -- for same legislation wont trigger PK error
1745: select distinct *
1746: from hr_s_balance_classifications hsbc
1747: where balance_type_id = bal_type_id
1748: and not exists
1749: ( select 1
1750: from pay_balance_classifications pbc

Line 1836: update /+NO_INDEX/ hr_s_BALANCE_CLASSIFICATIONS

1832:
1833: --conflict may exist
1834: --update all balance_type_id's to remove conflict
1835:
1836: update /*+NO_INDEX*/ hr_s_BALANCE_CLASSIFICATIONS
1837: set balance_type_id = balance_type_id - 50000000;
1838:
1839: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
1840: set balance_type_id = balance_type_id - 50000000;

Line 2027: update hr_s_balance_classifications

2023: set key_value = to_char(l_new_surrogate_key)
2024: where key_value = to_char(stu_rec.c_surrogate_key)
2025: and key_name = 'BALANCE_TYPE_ID';
2026:
2027: update hr_s_balance_classifications
2028: set balance_type_id = l_new_surrogate_key
2029: where balance_type_id = stu_rec.c_surrogate_key;
2030:
2031: update hr_s_balance_feeds_f

Line 2093: delete from hr_s_balance_classifications

2089:
2090: BEGIN
2091:
2092:
2093: delete from hr_s_balance_classifications
2094: where balance_type_id = stu_Rec.c_surrogate_key;
2095:
2096:
2097: delete from hr_s_defined_balances

Line 2436: from hr_s_balance_classifications hsbc