APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_US_STATES

Line 115: FROM pay_us_states

111: WHERE payroll_action_id = p_pactid;
112: IF p_state_abbrev <> 'FED' THEN
113: SELECT state_code
114: INTO p_state_code
115: FROM pay_us_states
116: WHERE state_abbrev = p_state_abbrev;
117: hr_utility.set_location
118: ('pay_us_mmref_reporting_mt.get_report_parameters', 20);
119: ELSE

Line 1515: from pay_us_states

1511: IS
1512: /* get the state Code */
1513: CURSOR c_state_code(cp_state varchar2 )
1514: IS select state_code
1515: from pay_us_states
1516: WHERE state_abbrev = cp_state;
1517:
1518: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1519: IS

Line 1566: l_w2_state pay_us_states.state_code%type;

1562: and con3.context_id = fc3.context_id
1563: and substr(ltrim(rtrim(con3.context)),1,2) = ltrim(rtrim(cp_state_code));
1564: /* jurisdiction code of the state */
1565: /* local Variables */
1566: l_w2_state pay_us_states.state_code%type;
1567: l_tax_unit_id number;
1568: l_payroll_action_id number;
1569: l_state_code varchar2(2);
1570: l_info varchar2(80);