APPS.PAY_ASG_GEO_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 21: FROM per_assignments_f paf, hr_soft_coding_keyflex hsck

17:
18: CURSOR csr_date_and_gre IS
19: SELECT distinct --Bug 4671218 paf.effective_start_date, paf.effective_end_date,
20: hsck.segment1 tax_unit_id
21: FROM per_assignments_f paf, hr_soft_coding_keyflex hsck
22: WHERE paf.assignment_id = P_assignment_id
23: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
24:
25: v_tax_unit_id NUMBER;

Line 166: hr_soft_coding_keyflex hsck,

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
170: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 176: hr_soft_coding_keyflex hsck,

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
180: AND paf.assignment_id = pect.assignment_id

Line 187: hr_soft_coding_keyflex hsck,

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
191: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 197: hr_soft_coding_keyflex hsck,

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
201: AND paf.assignment_id = pect.assignment_id

Line 209: hr_soft_coding_keyflex hsck,

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
213: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;