APPS.PAY_US_MMREF_LOCAL dependencies on PAY_US_STATES

Line 159: FROM pay_us_states

155: WHERE payroll_action_id = p_pactid;
156: IF p_state_abbrev <> 'FED' THEN
157: SELECT state_code
158: INTO p_state_code
159: FROM pay_us_states
160: WHERE state_abbrev = p_state_abbrev;
161: hr_utility.set_location
162: ('pay_us_mmref_reporting.get_report_parameters', 20);
163: ELSE

Line 1421: from pay_us_states

1417: IS
1418: /* get the state Code */
1419: CURSOR c_state_code(cp_state varchar2 )
1420: IS select state_code
1421: from pay_us_states
1422: WHERE state_abbrev = cp_state;
1423:
1424: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
1425: IS

Line 1466: l_w2_state pay_us_states.state_code%type;

1462: and con3.context_id = fc3.context_id
1463: and substr(ltrim(rtrim(con3.context)),1,2) = ltrim(rtrim(cp_state_code));
1464: /* jurisdiction code of the state */
1465: /* local Variables */
1466: l_w2_state pay_us_states.state_code%type;
1467: l_tax_unit_id number;
1468: l_payroll_action_id number;
1469: l_state_code varchar2(2);
1470: l_info varchar2(80);