APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on PAY_US_GEO_UPD_PKG

Line 2019: AND pay_us_geo_upd_pkg.get_city(paf.person_id, paf.location_id, ectr.state_code,

2015: AND pmod.old_city_code = ectr.city_code
2016: AND ectr.assignment_id = paf.assignment_id
2017: AND paf.person_id = ppf.person_id
2018: AND pmod.patch_name = cp_geocode_patch_name
2019: AND pay_us_geo_upd_pkg.get_city(paf.person_id, paf.location_id, ectr.state_code,
2020: ectr.county_code,ectr.city_code,pmod.city_name,pmod.patch_name,pmod.process_type) = pmod.city_name
2021: UNION
2022: SELECT /*+ ORDERED
2023: INDEX (PAY_US_MODIFIED_GEOCODES PAY_US_MODIFIED_GEOCODES_N1)

Line 2045: AND pay_us_geo_upd_pkg.get_city(paf.person_id, paf.location_id, ectr.state_code,

2041: AND ectr.assignment_id = paf.assignment_id
2042: AND paf.person_id = ppf.person_id
2043: AND pmod.patch_name = cp_geocode_patch_name
2044: AND pmod2.patch_name = cp_geocode_patch_name
2045: AND pay_us_geo_upd_pkg.get_city(paf.person_id, paf.location_id, ectr.state_code,
2046: ectr.county_code,ectr.city_code,pmod.city_name,pmod.patch_name,pmod.process_type) = pmod.city_name;
2047:
2048:
2049: ln_full_name varchar2(40);