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 138: pay_defined_balances pdb

134: pbt.legislation_code,
135: pdb.defined_balance_id
136: FROM pay_balance_types pbt,
137: pay_balance_dimensions pbd,
138: pay_defined_balances pdb
139: WHERE pdb.balance_type_id = pbt.balance_type_id
140: AND pdb.balance_dimension_id = pbd.balance_dimension_id
141: AND pbt.balance_type_id = p_balance_type_id
142: AND pbd.balance_dimension_id = p_balance_dimension_id;

Line 545: pay_defined_balances pdb

541: p_dimension IN CHAR) IS
542: SELECT pdb.defined_balance_id
543: FROM pay_balance_types pbt,
544: pay_balance_dimensions pbd,
545: pay_defined_balances pdb
546: WHERE pdb.balance_type_id = pbt.balance_type_id
547: AND pdb.balance_dimension_id = pbd.balance_dimension_id
548: AND pbt.balance_name = p_balance
549: AND pbd.database_item_suffix = p_dimension

Line 776: FROM pay_defined_balances pdb,

772: BETWEEN effective_start_date AND effective_end_date;
773:
774: CURSOR csr_get_prsi_week_id IS
775: SELECT pdb.defined_balance_id
776: FROM pay_defined_balances pdb,
777: pay_balance_types pbt,
778: pay_balance_dimensions pbd
779: WHERE pbd.dimension_name = '_ASG_YTD'
780: AND pbd.legislation_code = 'IE'