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.

APPS.PAY_ASG_GEO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 165: FROM per_all_assignments_f paf,

161:
162: CURSOR csr_city_asg_info IS -- get local geos
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

Line 175: FROM per_all_assignments_f paf,

171: UNION ALL -- get school districts (CITY)
172: SELECT DISTINCT
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

Line 186: FROM per_all_assignments_f paf,

182:
183: CURSOR csr_county_asg_info IS -- get county codes
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

Line 196: FROM per_all_assignments_f paf,

192: UNION ALL -- get school districts (COUNTY)
193: SELECT DISTINCT
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

Line 208: FROM per_all_assignments_f paf,

204:
205: CURSOR csr_state_asg_info IS -- get state codes
206: SELECT DISTINCT
207: paf.assignment_id, hsck.segment1 tax_unit_id, pest.jurisdiction_code
208: FROM per_all_assignments_f paf,
209: hr_soft_coding_keyflex hsck,
210: pay_us_emp_state_tax_rules_f pest
211: WHERE paf.assignment_id = p_assignment_id
212: AND paf.assignment_id = pest.assignment_id