eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_ASG_GEO_PKG dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 188: pay_us_emp_county_tax_rules_f pect

184: SELECT DISTINCT
185: paf.assignment_id, hsck.segment1 tax_unit_id, pect.jurisdiction_code
186: FROM per_all_assignments_f paf,
187: hr_soft_coding_keyflex hsck,
188: pay_us_emp_county_tax_rules_f pect
189: WHERE paf.assignment_id = p_assignment_id
190: AND paf.assignment_id = pect.assignment_id
191: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
192: UNION ALL -- get school districts (COUNTY)

Line 198: pay_us_emp_county_tax_rules_f pect

194: paf.assignment_id, hsck.segment1 tax_unit_id,
195: substr(jurisdiction_code,1,2)||'-'||pect.school_district_code
196: FROM per_all_assignments_f paf,
197: hr_soft_coding_keyflex hsck,
198: pay_us_emp_county_tax_rules_f pect
199: WHERE paf.assignment_id = p_assignment_id
200: AND pect.school_district_code IS NOT NULL
201: AND paf.assignment_id = pect.assignment_id
202: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;