APPS.PAY_US_MMREF_REPORTING dependencies on PAY_US_STATES

Line 217: FROM pay_us_states

213: WHERE payroll_action_id = p_pactid;
214: IF p_state_abbrev <> 'FED' THEN
215: SELECT state_code
216: INTO p_state_code
217: FROM pay_us_states
218: WHERE state_abbrev = p_state_abbrev;
219: hr_utility.set_location
220: ('pay_us_mmref_reporting.get_report_parameters', 20);
221: ELSE

Line 2003: from pay_us_states

1999: IS
2000: /* get the state Code */
2001: CURSOR c_state_code(cp_state varchar2 )
2002: IS select state_code
2003: from pay_us_states
2004: WHERE state_abbrev = cp_state;
2005:
2006: CURSOR c_yep_tax_unit_ppa_id(cp_payroll_action_id number )
2007: IS

Line 2054: l_w2_state pay_us_states.state_code%type;

2050: and con3.context_id = fc3.context_id
2051: and substr(ltrim(rtrim(con3.context)),1,2) = ltrim(rtrim(cp_state_code));
2052: /* jurisdiction code of the state */
2053: /* local Variables */
2054: l_w2_state pay_us_states.state_code%type;
2055: l_tax_unit_id number;
2056: l_payroll_action_id number;
2057: l_state_code varchar2(2);
2058: l_info varchar2(80);