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_SG_AWCAP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 610: pay_balance_dimensions pbd

606: is
607: select pdb.defined_balance_id
608: from pay_defined_balances pdb,
609: pay_balance_types pbt,
610: pay_balance_dimensions pbd
611: where pbt.balance_name = p_balance_name
612: and pbd.dimension_name = p_dimension_name
613: and pbt.balance_type_id = pdb.balance_type_id
614: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 798: pay_balance_dimensions pbd

794: g_ytd_def_bal_tbl,
795: g_bal_name_tbl
796: from pay_balance_types pbt,
797: pay_defined_balances pdb,
798: pay_balance_dimensions pbd
799: where pbt.legislation_code = 'SG'
800: and pbd.legislation_code = pbt.legislation_code
801: and pdb.legislation_code = pbt.legislation_code
802: and pbt.balance_name in ( 'CPF Additional Earnings Eligible Comp',

Line 814: pay_balance_dimensions pbd

810: bulk collect into
811: g_mtd_def_bal_tbl
812: from pay_balance_types pbt,
813: pay_defined_balances pdb,
814: pay_balance_dimensions pbd
815: where pbt.legislation_code = 'SG'
816: and pbd.legislation_code = pbt.legislation_code
817: and pdb.legislation_code = pbt.legislation_code
818: and pbt.balance_name in ('Employee CPF Contributions Additional Earnings',