APPS.PAY_NEGBAL_PKG dependencies on PAY_US_STATES

Line 138: l_state pay_us_states.state_abbrev%type;

134: ----------------------------------- range_cursor ----------------------------------
135: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
136: l_payroll_id number;
137: leg_param pay_payroll_actions.legislative_parameters%type;
138: l_state pay_us_states.state_abbrev%type;
139: --
140: begin
141: select legislative_parameters,
142: pay_negbal_pkg.get_parameter('TRANSFER_STATE',

Line 189: l_state pay_us_states.state_abbrev%type;

185: stperson in number,
186: endperson in number,
187: chunk in number) is
188:
189: l_state pay_us_states.state_abbrev%type;
190: greid number;
191: lockedactid number;
192: lockingactid number;
193: assignid number;

Line 351: pay_us_states pst

347:
348: select count(*)
349: into l_sui_exempt
350: from pay_us_emp_state_tax_rules_f ptax,
351: pay_us_states pst
352: where ptax.assignment_id = assignid
353: and ptax.effective_start_date <= l_qtr_end
354: and ptax.effective_end_date >= l_qtr_start
355: and pst.state_code = ptax.state_code

Line 360: pay_us_states pst

356: and pst.state_abbrev = l_state
357: and ptax.sui_exempt = 'Y'
358: and not exists ( select 'x'
359: from pay_us_emp_state_tax_rules_f ptax,
360: pay_us_states pst
361: where ptax.assignment_id = assignid
362: and ptax.effective_start_date <= l_qtr_end
363: and ptax.effective_end_date >= l_qtr_start
364: and pst.state_code = ptax.state_code