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.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_DEFINED_BALANCES

Line 658: pay_defined_balances PDB,

654: CURSOR c_defined_balance IS
655: SELECT
656: defined_balance_id
657: FROM
658: pay_defined_balances PDB,
659: pay_balance_dimensions PBD,
660: pay_balance_types_tl PBT_TL,
661: pay_balance_types PBT
662: WHERE PBT_TL.balance_type_id = PBT.balance_type_id

Line 1912: pay_defined_balances pdb

1908: CURSOR c_balance_check(user_balance varchar2) IS
1909: SELECT 1
1910: FROM pay_balance_types pbt,
1911: pay_balance_dimensions pbd,
1912: pay_defined_balances pdb
1913: WHERE pdb.balance_type_id = pbt.balance_type_id
1914: AND pdb.balance_dimension_id = pbd.balance_dimension_id
1915: AND pbt.balance_name = user_balance
1916: AND nvl(pbt.legislation_code,'GB') = 'GB'

Line 1925: pay_defined_balances pdb

1921: SELECT pbt.balance_name,
1922: pbd.database_item_suffix
1923: FROM pay_balance_types pbt,
1924: pay_balance_dimensions pbd,
1925: pay_defined_balances pdb
1926: WHERE pbt.balance_type_id = pdb.balance_type_id
1927: AND pbd.balance_dimension_id = pdb.balance_dimension_id
1928: AND row_name = pbt.balance_name || pbd.database_item_suffix;
1929: