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_DEFINED_BALANCES

Line 292: pay_defined_balances pdb

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
295: AND pbt.balance_type_id = p_balance_type_id
296: AND pbd.balance_dimension_id = p_balance_dimension_id;

Line 702: pay_defined_balances pdb

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
705: AND pbt.balance_name = p_balance
706: AND pbd.database_item_suffix = p_dimension

Line 965: FROM pay_defined_balances pdb,

961: BETWEEN effective_start_date AND effective_end_date;
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'