DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on HR_LOCATIONS

Line 1156: hr_locations hl

1152: BEGIN
1153: select hu.location_id,hl.ece_tp_location_code, hl.location_code
1154: into l_ship_from_addr_id, l_ship_from_location_code,l_ship_from_addr_code
1155: from hr_all_organization_units hu,
1156: hr_locations hl
1157: where hl.location_id = hu.location_id
1158: AND hu.organization_id = l_line_tbl(I).ship_from_org_id;
1159:
1160: IF l_debug_level > 0 THEN

Line 1227: hr_locations hl

1223: BEGIN
1224: select hu.location_id,hl.ece_tp_location_code, hl.location_code
1225: into l_ship_from_addr_id, l_ship_from_location_code,l_ship_from_addr_code
1226: from hr_all_organization_units hu,
1227: hr_locations hl
1228: where hl.location_id = hu.location_id
1229: AND hu.organization_id = l_header_rec.ship_from_org_id;
1230:
1231: IF l_debug_level > 0 THEN