DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 570: FROM pay_us_emp_fed_tax_rules_f peft,

566: RETURN number IS
567:
568: CURSOR emp_qtr_sui_state_count IS
569: SELECT COUNT(DISTINCT peft.sui_state_code)
570: FROM pay_us_emp_fed_tax_rules_f peft,
571: per_all_assignments_f paa,
572: hr_soft_coding_keyflex hscf
573: WHERE peft.effective_end_date >= trunc(p_effective_date,'Q')
574: AND peft.effective_start_date <= p_effective_date