APPS.PAY_US_W2C_RPT dependencies on PAY_US_CODE_W2C_V

Line 1425: from pay_us_code_w2c_v

1421:
1422: CURSOR c_get_box12_info (p_asg_action_id NUMBER) IS
1423: select w2_balance_code,
1424: trim(to_char(decode(w2_balance_code_value,0,null,w2_balance_code_value),'9999999990.99'))
1425: from pay_us_code_w2c_v
1426: where assignment_action_id = p_asg_action_id
1427: and tax_unit_id = p_tax_unit_id
1428: order by w2_balance_code;
1429:

Line 1433: from pay_us_code_w2c_v

1429:
1430: CURSOR c_get_box12_info_o (p_prev_asg_action_id NUMBER,p_code varchar2) IS
1431: select w2_balance_code,
1432: trim(to_char(decode(w2_balance_code_value,0,null,w2_balance_code_value),'9999999990.99'))
1433: from pay_us_code_w2c_v
1434: where assignment_action_id = p_prev_asg_action_id
1435: and w2_balance_code = p_code
1436: and tax_unit_id = p_tax_unit_id
1437: order by w2_balance_code;