APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_SHIPMENTS

Line 5957: from ASO_shipments

5953: --shipTo
5954: cursor c_check_shipTo_rec_exist(l_quote_header_id number)
5955: is
5956: select shipment_id, SHIP_TO_PARTY_SITE_ID
5957: from ASO_shipments
5958: where QUOTE_HEADER_ID = l_quote_header_id and
5959: quote_line_id is null;
5960: rec_shipTo_rec_exist c_check_shipTo_rec_exist%rowtype;
5961:

Line 5965: from ASO_shipments

5961:
5962: cursor c_check_shipTo_partyId(l_quote_header_id number)
5963: is
5964: select ship_to_party_id
5965: from ASO_shipments
5966: where QUOTE_HEADER_ID = l_quote_header_id and
5967: quote_line_id is null and
5968: SHIP_TO_CUST_ACCOUNT_ID is null and
5969: SHIP_TO_PARTY_SITE_ID is null;

Line 6274: from ASO_shipments

6270:
6271: cursor c_check_shipTo_rec_exist(l_quote_header_id number)
6272: is
6273: select shipment_id, SHIP_METHOD_CODE
6274: from ASO_shipments
6275: where QUOTE_HEADER_ID = l_quote_header_id and
6276: quote_line_id is null;
6277: rec_shipTo_rec_exist c_check_shipTo_rec_exist%rowtype;
6278:

Line 6959: from aso_shipments

6955:
6956: cursor c_get_shipTo_info(l_quote_header_id number)
6957: is
6958: select SHIP_TO_CUST_ACCOUNT_ID, ship_to_party_id, ship_to_party_site_id
6959: from aso_shipments
6960: where QUOTE_HEADER_ID = l_quote_header_id and
6961: quote_line_id is null;
6962: rec_shipTo_info c_get_shipTo_info%rowtype;
6963: