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 1541: from hr_s_balance_classifications hsbc

1537: -- Cursor for installation of classification rules
1538: -- ADDED DISTINCT so that ldts that contains same bal_class
1539: -- for same legislation wont trigger PK error
1540: select distinct *
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

Line 1631: update /+NO_INDEX/ hr_s_BALANCE_CLASSIFICATIONS

1627:
1628: --conflict may exist
1629: --update all balance_type_id's to remove conflict
1630:
1631: update /*+NO_INDEX*/ hr_s_BALANCE_CLASSIFICATIONS
1632: set balance_type_id = balance_type_id - 50000000;
1633:
1634: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
1635: set balance_type_id = balance_type_id - 50000000;

Line 1810: update hr_s_balance_classifications

1806: set key_value = to_char(l_new_surrogate_key)
1807: where key_value = to_char(stu_rec.c_surrogate_key)
1808: and key_name = 'BALANCE_TYPE_ID';
1809:
1810: update hr_s_balance_classifications
1811: set balance_type_id = l_new_surrogate_key
1812: where balance_type_id = stu_rec.c_surrogate_key;
1813:
1814: update hr_s_balance_feeds_f

Line 1876: delete from hr_s_balance_classifications

1872:
1873: BEGIN
1874:
1875:
1876: delete from hr_s_balance_classifications
1877: where balance_type_id = stu_Rec.c_surrogate_key;
1878:
1879:
1880: delete from hr_s_defined_balances

Line 2209: from hr_s_balance_classifications hsbc