DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 2709: from pay_us_emp_city_tax_rules_f pcty

2705: and pcnt.effective_end_date >= p_start_date;
2706:
2707: cursor c_get_city_school_district is
2708: select pcty.jurisdiction_code
2709: from pay_us_emp_city_tax_rules_f pcty
2710: where pcty.assignment_id = p_assignment_id
2711: and pcty.school_district_code = substr(p_school_jurisdiction,4,5)
2712: and pcty.state_code = substr(p_school_jurisdiction,1,2)
2713: and pcty.effective_start_date <= p_end_date