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

Line 423: pay_balance_types pbt,

419: cursor ytd_A8A_balances is
420: select fue.user_entity_id,
421: pdb.defined_balance_id def_bal_id
422: from ff_user_entities fue,
423: pay_balance_types pbt,
424: pay_defined_balances pdb,
425: pay_balance_dimensions pbd
426: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
427: and fue.legislation_code = 'SG'

Line 921: pay_balance_types pbt,

917: cursor ytd_balances_ir8s is
918: select fue.user_entity_id,
919: pdb.defined_balance_id def_bal_id
920: from ff_user_entities fue,
921: pay_balance_types pbt,
922: pay_defined_balances pdb,
923: pay_balance_dimensions pbd
924: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
925: and fue.legislation_code = 'SG'

Line 951: pay_balance_types pbt,

947: cursor ytd_balances_ir8a is
948: select fue.user_entity_id,
949: pdb.defined_balance_id def_bal_id
950: from ff_user_entities fue,
951: pay_balance_types pbt,
952: pay_defined_balances pdb,
953: pay_balance_dimensions pbd
954: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_YTD'
955: and fue.legislation_code = 'SG'

Line 1026: pay_balance_types pbt,

1022: is
1023: select fue.user_entity_id,
1024: pdb.defined_balance_id def_bal_id
1025: from ff_user_entities fue,
1026: pay_balance_types pbt,
1027: pay_defined_balances pdb,
1028: pay_balance_dimensions pbd
1029: where fue.user_entity_name = 'X_' || upper(replace(pbt.balance_name,' ','_')) || '_PER_LE_MONTH'
1030: and fue.legislation_code = 'SG'