APPS.PAY_US_GEO_UPD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 74: per_all_assignments_f paf,

70:
71: sqlstr := ' select distinct paf.person_id
72: from pay_us_modified_geocodes mg,
73: pay_us_emp_city_tax_rules_f tr,
74: per_all_assignments_f paf,
75: pay_us_states pus
76: where mg.patch_name = '''||ln_upgrade_patch||'''
77: and mg.state_code = pus.state_code
78: and mg.state_code = tr.state_code

Line 125: FROM per_all_assignments_f paf,

121: endperson number
122: ) is
123:
124: SELECT distinct ectr.assignment_id
125: FROM per_all_assignments_f paf,
126: pay_us_emp_city_tax_rules_f ectr,
127: pay_us_modified_geocodes pmod
128: WHERE pmod.state_code = ectr.state_code
129: AND pmod.county_code = ectr.county_code

Line 148: FROM per_all_assignments_f paf,

144: and pugu.id = l_geo_phase_id)
145: UNION ALL
146:
147: SELECT distinct pac.assignment_id
148: FROM per_all_assignments_f paf,
149: pay_action_contexts pac,
150: pay_us_modified_geocodes pmod
151: WHERE pmod.state_code = 'CA'
152: AND pmod.county_code = pac.context_value

Line 736: FROM per_all_assignments_f paf,

732: CURSOR main_driving_cur(P_ASSIGN_START NUMBER, P_ASSIGN_END NUMBER, P_CITY_NAME VARCHAR2, P_API_MODE VARCHAR2) IS
733: SELECT distinct ectr.jurisdiction_code, ectr.assignment_id,
734: pmod.state_code||'-'||pmod.county_code||'-'||pmod.new_city_code jd_code,
735: paf.person_id, pmod.new_city_code, pmod.process_type, ectr.emp_city_tax_rule_id
736: FROM per_all_assignments_f paf,
737: pay_us_emp_city_tax_rules_f ectr,
738: pay_us_modified_geocodes pmod
739: WHERE pmod.state_code = ectr.state_code
740: AND pmod.county_code = ectr.county_code

Line 764: FROM per_all_assignments_f paf,

760: SELECT distinct pac.context_value, pac.assignment_id,
761: pmod.new_county_code jd_code,
762: paf.person_id, pmod.new_city_code, pmod.process_type,
763: pac.context_id
764: FROM per_all_assignments_f paf,
765: pay_action_contexts pac,
766: pay_us_modified_geocodes pmod
767: WHERE pmod.state_code = 'CA'
768: AND pmod.county_code = pac.context_value

Line 2491: per_all_assignments_f paf

2487:
2488: SELECT ppf.person_id
2489: INTO l_person_id
2490: FROM per_all_people_f ppf,
2491: per_all_assignments_f paf
2492: WHERE ppf.person_id = paf.person_id
2493: AND paf.assignment_id = p_assign_id
2494: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
2495: FROM per_all_people_f ppf2