APPS.PAY_US_MMREF_REPORTING dependencies on PAY_US_STATES

Line 232: FROM pay_us_states

228: WHERE payroll_action_id = p_pactid;
229: IF p_state_abbrev <> 'FED' THEN
230: SELECT state_code
231: INTO p_state_code
232: FROM pay_us_states
233: WHERE state_abbrev = p_state_abbrev;
234: hr_utility.set_location
235: ('pay_us_mmref_reporting.get_report_parameters', 20);
236: ELSE

Line 2495: from pay_us_states

2491: IS
2492: /* get the state Code */
2493: CURSOR c_state_code(cp_state varchar2 )
2494: IS select state_code
2495: from pay_us_states
2496: WHERE state_abbrev = cp_state;
2497:
2498: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
2499: IS

Line 2546: l_w2_state pay_us_states.state_code%type;

2542: and con3.context_id = fc3.context_id
2543: and substr(ltrim(rtrim(con3.context)),1,2) = ltrim(rtrim(cp_state_code));
2544: /* jurisdiction code of the state */
2545: /* local Variables */
2546: l_w2_state pay_us_states.state_code%type;
2547: l_tax_unit_id number;
2548: l_payroll_action_id number;
2549: l_state_code varchar2(2);
2550: l_info varchar2(80);