APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_SHIPMENTS

Line 5853: from ASO_shipments

5849: --shipTo
5850: cursor c_check_shipTo_rec_exist(l_quote_header_id number)
5851: is
5852: select shipment_id, SHIP_TO_PARTY_SITE_ID
5853: from ASO_shipments
5854: where QUOTE_HEADER_ID = l_quote_header_id and
5855: quote_line_id is null;
5856: rec_shipTo_rec_exist c_check_shipTo_rec_exist%rowtype;
5857:

Line 5861: from ASO_shipments

5857:
5858: cursor c_check_shipTo_partyId(l_quote_header_id number)
5859: is
5860: select ship_to_party_id
5861: from ASO_shipments
5862: where QUOTE_HEADER_ID = l_quote_header_id and
5863: quote_line_id is null and
5864: SHIP_TO_CUST_ACCOUNT_ID is null and
5865: SHIP_TO_PARTY_SITE_ID is null;

Line 6170: from ASO_shipments

6166:
6167: cursor c_check_shipTo_rec_exist(l_quote_header_id number)
6168: is
6169: select shipment_id, SHIP_METHOD_CODE
6170: from ASO_shipments
6171: where QUOTE_HEADER_ID = l_quote_header_id and
6172: quote_line_id is null;
6173: rec_shipTo_rec_exist c_check_shipTo_rec_exist%rowtype;
6174:

Line 6823: from aso_shipments

6819:
6820: cursor c_get_shipTo_info(l_quote_header_id number)
6821: is
6822: select SHIP_TO_CUST_ACCOUNT_ID, ship_to_party_id, ship_to_party_site_id
6823: from aso_shipments
6824: where QUOTE_HEADER_ID = l_quote_header_id and
6825: quote_line_id is null;
6826: rec_shipTo_info c_get_shipTo_info%rowtype;
6827: