APPS.ZX_VTX_USER_PKG dependencies on HR_LOCATIONS_ALL

Line 2029: FROM hr_locations_all lc, hr_organization_units hr

2025: IF l_ship_from_party_id IS NOT NULL THEN
2026: BEGIN
2027: SELECT lc.loc_information13,lc.loc_information14
2028: INTO l_sfr_geocode,l_sfr_in_out_flag
2029: FROM hr_locations_all lc, hr_organization_units hr
2030: WHERE hr.organization_id = l_ship_from_party_id
2031: AND hr.location_id = lc.location_id;
2032: EXCEPTION
2033: WHEN OTHERS THEN

Line 2036: FROM hr_locations_all lc

2032: EXCEPTION
2033: WHEN OTHERS THEN
2034: SELECT lc.loc_information13,lc.loc_information14
2035: INTO l_sfr_geocode,l_sfr_in_out_flag
2036: FROM hr_locations_all lc
2037: WHERE lc.location_id = l_ship_from_location_id;
2038: END;
2039: END IF;
2040:

Line 2045: FROM hr_locations_all lc

2041: IF l_sfr_geocode IS NULL THEN
2042:
2043: SELECT lc.loc_information13,lc.loc_information14
2044: INTO l_sfr_geocode,l_sfr_in_out_flag
2045: FROM hr_locations_all lc
2046: WHERE lc.location_id = l_ship_from_location_id;
2047:
2048: END IF;
2049:

Line 2074: FROM hr_locations_all lc, hr_organization_units hr

2070: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
2071:
2072: SELECT lc.loc_information13,lc.loc_information14
2073: INTO l_sfr_geocode,l_sfr_in_out_flag
2074: FROM hr_locations_all lc, hr_organization_units hr
2075: WHERE hr.organization_id = l_master_org_id
2076: AND hr.location_id = lc.location_id;
2077: END IF;
2078: END IF;