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_US_GEO_UPD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 234: per_all_assignments_f paf,

230:
231: sqlstr := ' select distinct paf.person_id
232: from pay_us_modified_geocodes mg,
233: pay_us_emp_city_tax_rules_f tr,
234: per_all_assignments_f paf,
235: pay_us_states pus
236: where mg.patch_name = '''||ln_upgrade_patch||'''
237: and mg.state_code = pus.state_code
238: and mg.state_code = tr.state_code

Line 285: FROM per_all_assignments_f paf,

281: endperson number
282: ) is
283:
284: SELECT distinct ectr.assignment_id
285: FROM per_all_assignments_f paf,
286: pay_us_emp_city_tax_rules_f ectr,
287: pay_us_modified_geocodes pmod
288: WHERE pmod.state_code = ectr.state_code
289: AND pmod.county_code = ectr.county_code

Line 310: FROM per_all_assignments_f paf,

306: and pugu.id = l_geo_phase_id)
307: UNION ALL
308:
309: SELECT distinct pac.assignment_id
310: FROM per_all_assignments_f paf,
311: pay_action_contexts pac,
312: pay_us_modified_geocodes pmod
313: WHERE pmod.state_code = 'CA'
314: AND pmod.county_code = pac.context_value

Line 945: FROM per_all_assignments_f paf,

941: CURSOR main_driving_cur(P_ASSIGN_START NUMBER, P_ASSIGN_END NUMBER, P_CITY_NAME VARCHAR2, P_API_MODE VARCHAR2) IS
942: SELECT distinct ectr.jurisdiction_code, ectr.assignment_id,
943: pmod.state_code||'-'||pmod.county_code||'-'||pmod.new_city_code jd_code,
944: paf.person_id, pmod.new_city_code, pmod.process_type, ectr.emp_city_tax_rule_id
945: FROM per_all_assignments_f paf,
946: pay_us_emp_city_tax_rules_f ectr,
947: pay_us_modified_geocodes pmod
948: WHERE pmod.state_code = ectr.state_code
949: AND pmod.county_code = ectr.county_code

Line 973: FROM per_all_assignments_f paf,

969: SELECT distinct pac.context_value, pac.assignment_id,
970: pmod.new_county_code jd_code,
971: paf.person_id, pmod.new_city_code, pmod.process_type,
972: pac.context_id
973: FROM per_all_assignments_f paf,
974: pay_action_contexts pac,
975: pay_us_modified_geocodes pmod
976: WHERE pmod.state_code = 'CA'
977: AND pmod.county_code = pac.context_value

Line 2784: per_all_assignments_f paf

2780:
2781: SELECT ppf.person_id
2782: INTO l_person_id
2783: FROM per_all_people_f ppf,
2784: per_all_assignments_f paf
2785: WHERE ppf.person_id = paf.person_id
2786: AND paf.assignment_id = p_assign_id
2787: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
2788: FROM per_all_people_f ppf2