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

Line 2207: from pay_balance_types pbt,

2203: SUI_ER_FL_ADJ_TAXABLE_PER_JD_GRE_QTD and this new value is used in SQWL reporting*/
2204:
2205: CURSOR get_defined_balance_id IS
2206: select pdb.defined_balance_id,pbd.dimension_name
2207: from pay_balance_types pbt,
2208: pay_balance_dimensions pbd,
2209: pay_defined_balances pdb
2210: where pbt.legislation_code = 'US'
2211: and pbt.balance_name = 'SUI ER Taxable'

Line 2221: from pay_balance_types pbt,

2217: and pdb.balance_dimension_id = pbd.balance_dimension_id;
2218:
2219: CURSOR c_get_defined_balance_id_oh IS
2220: select pdb.defined_balance_id,pbd.dimension_name
2221: from pay_balance_types pbt,
2222: pay_balance_dimensions pbd,
2223: pay_defined_balances pdb
2224: where pbt.legislation_code = 'US'
2225: and pbt.balance_name = 'SUI ER Taxable'

Line 2292: from pay_balance_types pbt,

2288:
2289: -- Cursor to get the Defined Balance IDs
2290: CURSOR c_get_defined_balance_id_ar IS
2291: select pdb.defined_balance_id, pbt.balance_name, pbd.dimension_name
2292: from pay_balance_types pbt,
2293: pay_balance_dimensions pbd,
2294: pay_defined_balances pdb
2295: where pbt.legislation_code = 'US'
2296: and (( pbt.balance_name = 'SUI ER Taxable'

Line 2412: l_balance_name pay_balance_types.balance_name%TYPE;

2408:
2409: /* End Bug#9356178*/
2410:
2411: /* Added for Bug#14097843 starts here */
2412: l_balance_name pay_balance_types.balance_name%TYPE;
2413:
2414: l_ar_jurisdiction_code VARCHAR2(11);
2415: l_ar_state_abbrev VARCHAR2(2);
2416: l_sui_ar_taxable_ytd NUMBER;