APPS.ZX_TAXWARE_USER_PKG dependencies on HR_LOCATIONS_ALL

Line 2060: FROM hr_locations_all lc, hr_organization_units hr

2056: IF arp_ship_from_add_tab(i) is NULL THEN
2057: BEGIN
2058: SELECT lc.loc_information13
2059: INTO arp_ship_from_add_tab(i)
2060: FROM hr_locations_all lc, hr_organization_units hr
2061: WHERE hr.organization_id = l_ship_from_party_id
2062: AND hr.location_id = lc.location_id;
2063:
2064: IF arp_ship_from_add_tab(i) IS NOT NULL THEN

Line 2073: FROM hr_locations_all lc

2069: EXCEPTION WHEN OTHERS THEN
2070: BEGIN
2071: SELECT lc.loc_information13
2072: INTO arp_ship_from_add_tab(i)
2073: FROM hr_locations_all lc
2074: WHERE lc.location_id = l_ship_from_location_id;
2075:
2076: IF arp_ship_from_add_tab(i) IS NOT NULL THEN
2077: arp_ship_from_add_tab(i) := '1'||arp_ship_from_add_tab(i);