DBA Data[Home] [Help]

APPS.PAY_ASG_GEO_PKG dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 167: pay_us_emp_city_tax_rules_f pect

163: SELECT DISTINCT
164: paf.assignment_id, hsck.segment1 tax_unit_id, pect.jurisdiction_code
165: FROM per_all_assignments_f paf,
166: hr_soft_coding_keyflex hsck,
167: pay_us_emp_city_tax_rules_f pect
168: WHERE paf.assignment_id = p_assignment_id
169: AND paf.assignment_id = pect.assignment_id
170: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
171: UNION ALL -- get school districts (CITY)

Line 177: pay_us_emp_city_tax_rules_f pect

173: paf.assignment_id, hsck.segment1 tax_unit_id,
174: substr(jurisdiction_code,1,2)||'-'||pect.school_district_code
175: FROM per_all_assignments_f paf,
176: hr_soft_coding_keyflex hsck,
177: pay_us_emp_city_tax_rules_f pect
178: WHERE paf.assignment_id = p_assignment_id
179: AND pect.school_district_code IS NOT NULL
180: AND paf.assignment_id = pect.assignment_id
181: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;