DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on PAY_US_OTHER_W2C_V

Line 1442: from pay_us_other_w2c_v

1438:
1439: CURSOR c_get_box14_info (p_asg_action_id NUMBER) IS
1440: SELECT substr(w2_other_meaning,1,10) w2_other_code,
1441: trim(to_char(decode(w2_other_value,0,null,w2_other_value),'9999999990.99'))
1442: from pay_us_other_w2c_v
1443: where tax_unit_id = p_tax_unit_id
1444: and assignment_action_id = p_asg_action_id;
1445:
1446: CURSOR c_get_box14_info_o (p_prev_asg_action_id NUMBER, p_code varchar2) IS

Line 1449: from pay_us_other_w2c_v

1445:
1446: CURSOR c_get_box14_info_o (p_prev_asg_action_id NUMBER, p_code varchar2) IS
1447: SELECT substr(w2_other_meaning,1,10) w2_other_code,
1448: trim(to_char(decode(w2_other_value,0,null,w2_other_value),'9999999990.99'))
1449: from pay_us_other_w2c_v
1450: where tax_unit_id = p_tax_unit_id
1451: and substr(w2_other_meaning,1,10) = p_code
1452: and assignment_action_id = p_prev_asg_action_id;
1453: