APPS.ZX_VTX_USER_PKG dependencies on HR_ORGANIZATION_UNITS

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 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;