APPS.ZX_VTX_USER_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1879: FROM hr_locations_all lc, hr_organization_units hr

1875: IF l_ship_from_party_id IS NOT NULL THEN
1876: BEGIN
1877: SELECT lc.loc_information13,lc.loc_information14
1878: INTO l_sfr_geocode,l_sfr_in_out_flag
1879: FROM hr_locations_all lc, hr_organization_units hr
1880: WHERE hr.organization_id = l_ship_from_party_id
1881: AND hr.location_id = lc.location_id;
1882: EXCEPTION
1883: WHEN OTHERS THEN

Line 1924: FROM hr_locations_all lc, hr_organization_units hr

1920: l_master_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID', l_org_id);
1921:
1922: SELECT lc.loc_information13,lc.loc_information14
1923: INTO l_sfr_geocode,l_sfr_in_out_flag
1924: FROM hr_locations_all lc, hr_organization_units hr
1925: WHERE hr.organization_id = l_master_org_id
1926: AND hr.location_id = lc.location_id;
1927: END IF;
1928: END IF;