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

Line 408: pay_balance_types pbt,

404: cp_balance_dimension IN VARCHAR2)
405: IS
406: SELECT pdb.defined_balance_id
407: FROM pay_defined_balances pdb,
408: pay_balance_types pbt,
409: pay_balance_dimensions pbd
410: WHERE pbt.balance_name = cp_balance_name
411: AND pbt.legislation_code = 'US'
412: AND pbd.database_item_suffix = cp_balance_dimension

Line 533: pay_balance_types pbt,

529:
530: SELECT pdb.defined_balance_id
531: INTO ln_def_bal_id
532: FROM pay_defined_balances pdb,
533: pay_balance_types pbt,
534: pay_balance_dimensions pbd
535: WHERE pbt.balance_name = 'Gross Earnings'
536: AND pbt.legislation_code = 'US'
537: AND pbd.database_item_suffix = '_ASG_QTD'

Line 739: from pay_balance_types

735: select defined_balance_id, balance_type_id, balance_dimension_id
736: into ln_defined_balance_id, ln_balance_type_id, ln_balance_dimension_id
737: from pay_defined_balances
738: where balance_type_id = (select balance_type_id
739: from pay_balance_types
740: where balance_name = 'SS ER W11 Taxable'
741: and legislation_code = 'US')
742: and balance_dimension_id = (select balance_dimension_id
743: from pay_balance_dimensions