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_W2C_RPT dependencies on PAY_US_LOCALITY_W2C_V

Line 1461: FROM pay_us_locality_w2c_v

1457: trim(to_char(decode(w2_local_income_tax,0,'',w2_local_income_tax),'9999999990.99')) locality_tax,
1458: jurisdiction jurisdiction,
1459: state_abbrev state_code,
1460: tax_type
1461: FROM pay_us_locality_w2c_v
1462: WHERE assignment_action_id = p_asg_action_id
1463: and tax_unit_id = p_tax_unit_id
1464: order by state_code, tax_type;
1465: /* Bug # 9267579 */

Line 1470: FROM pay_us_locality_w2c_v

1466:
1467: CURSOR c_get_local_info_o (p_prev_asg_action_id NUMBER, p_tax_type varchar2, p_jurisdiction varchar2) IS
1468: SELECT trim(to_char(decode(w2_local_wages,0,'',w2_local_wages),'9999999990.99')) locality_wages,
1469: trim(to_char(decode(w2_local_income_tax,0,'',w2_local_income_tax),'9999999990.99')) locality_tax
1470: FROM pay_us_locality_w2c_v
1471: WHERE assignment_action_id = p_prev_asg_action_id
1472: and tax_unit_id = p_tax_unit_id
1473: and jurisdiction = p_jurisdiction
1474: and tax_type = p_tax_type;