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_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 290: FROM pay_balance_types pbt,

286: SELECT pbt.balance_name,
287: pbd.database_item_suffix,
288: pbt.legislation_code,
289: pdb.defined_balance_id
290: FROM pay_balance_types pbt,
291: pay_balance_dimensions pbd,
292: pay_defined_balances pdb
293: WHERE pdb.balance_type_id = pbt.balance_type_id
294: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 700: FROM pay_balance_types pbt,

696:
697: CURSOR csr_balance_dimension(p_balance IN CHAR,
698: p_dimension IN CHAR) IS
699: SELECT pdb.defined_balance_id
700: FROM pay_balance_types pbt,
701: pay_balance_dimensions pbd,
702: pay_defined_balances pdb
703: WHERE pdb.balance_type_id = pbt.balance_type_id
704: AND pdb.balance_dimension_id = pbd.balance_dimension_id

Line 966: pay_balance_types pbt,

962:
963: CURSOR csr_get_prsi_week_id IS
964: SELECT pdb.defined_balance_id
965: FROM pay_defined_balances pdb,
966: pay_balance_types pbt,
967: pay_balance_dimensions pbd
968: WHERE pbd.dimension_name = '_ASG_YTD'
969: AND pbd.legislation_code = 'IE'
970: AND pbt.balance_name = 'IE PRSI Insurable Weeks'