APPS.ZX_VTX_USER_PKG dependencies on HR_LOCATIONS_ALL

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 1886: FROM hr_locations_all lc

1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: SELECT lc.loc_information13,lc.loc_information14
1885: INTO l_sfr_geocode,l_sfr_in_out_flag
1886: FROM hr_locations_all lc
1887: WHERE lc.location_id = l_ship_from_location_id;
1888: END;
1889: END IF;
1890:

Line 1895: FROM hr_locations_all lc

1891: IF l_sfr_geocode IS NULL THEN
1892:
1893: SELECT lc.loc_information13,lc.loc_information14
1894: INTO l_sfr_geocode,l_sfr_in_out_flag
1895: FROM hr_locations_all lc
1896: WHERE lc.location_id = l_ship_from_location_id;
1897:
1898: END IF;
1899:

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;