DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on HR_LOCATIONS

Line 1129: hr_locations hl

1125: BEGIN
1126: select hu.location_id,hl.ece_tp_location_code, hl.location_code
1127: into l_ship_from_addr_id, l_ship_from_location_code,l_ship_from_addr_code
1128: from hr_all_organization_units hu,
1129: hr_locations hl
1130: where hl.location_id = hu.location_id
1131: AND hu.organization_id = l_line_tbl(I).ship_from_org_id;
1132:
1133: IF l_debug_level > 0 THEN

Line 1200: hr_locations hl

1196: BEGIN
1197: select hu.location_id,hl.ece_tp_location_code, hl.location_code
1198: into l_ship_from_addr_id, l_ship_from_location_code,l_ship_from_addr_code
1199: from hr_all_organization_units hu,
1200: hr_locations hl
1201: where hl.location_id = hu.location_id
1202: AND hu.organization_id = l_header_rec.ship_from_org_id;
1203:
1204: IF l_debug_level > 0 THEN