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_DEFINED_BALANCES

Line 366: pay_defined_balances pdb

362: cp_qtr IN varchar2,
363: cp_year IN varchar2) IS
364: SELECT NVL(SUM(prb.balance_value),0)
365: FROM pay_run_balances prb,
366: pay_defined_balances pdb
367: where pdb.balance_type_id = cp_balance_type_id
368: and pdb.balance_dimension_id = cp_balance_dimension_id
369: and pdb.defined_balance_id = prb.defined_balance_id
370: and prb.tax_unit_id = cp_tax_unit_id

Line 407: FROM pay_defined_balances pdb,

403: CURSOR get_defined_balance_id (cp_balance_name IN VARCHAR2,
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'

Line 532: FROM pay_defined_balances pdb,

528: /* Bug 9357061: The Splitting of the EIN End */
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'

Line 737: from pay_defined_balances

733: value to for 941 report
734:
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')