DBA Data[Home] [Help]

APPS.PAY_NEGBAL_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 350: from pay_us_emp_state_tax_rules_f ptax,

346: pay_balance_pkg.set_context('JURISDICTION_CODE',jd_code);
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

Line 359: from pay_us_emp_state_tax_rules_f ptax,

355: and pst.state_code = ptax.state_code
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