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 1422: from pay_us_states

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

Line 1467: l_w2_state pay_us_states.state_code%type;

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