APPS.IBE_ORD_ONECLICK_PVT dependencies on ASO_QUOTE_HEADERS

Line 673: FROM aso_quote_headers

669: l_count NUMBER := 0;
670:
671: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
672: SELECT quote_header_id, creation_date, currency_code
673: FROM aso_quote_headers
674: WHERE
675: quote_source_code = 'IStore Oneclick' and
676: party_id = c_party_id and
677: cust_account_id = c_acct_id and

Line 684: FROM ASO_QUOTE_HEADERS

680: nvl(trunc(quote_expiration_date), trunc(sysdate)+1) >= trunc(sysdate);
681:
682: CURSOR c_quote_date(c_qte_header_id NUMBER) IS
683: SELECT last_update_date
684: FROM ASO_QUOTE_HEADERS
685: WHERE quote_header_id = c_qte_header_id;
686:
687: BEGIN
688: --ibe_util.enable_debug;

Line 1181: FROM aso_quote_headers

1177: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1178:
1179: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1180: SELECT quote_header_id, creation_date, currency_code
1181: FROM aso_quote_headers
1182: WHERE quote_source_code = 'IStore Oneclick'
1183: and party_id = c_party_id
1184: and cust_account_id = c_acct_id
1185: and quote_name is null

Line 1205: FROM ASO_QUOTE_HEADERS

1201: and cust_account_id = c_acct_id;
1202:
1203: CURSOR c_quote_date(c_qte_header_id NUMBER) IS
1204: SELECT last_update_date
1205: FROM ASO_QUOTE_HEADERS
1206: WHERE quote_header_id = c_qte_header_id;
1207:
1208: CURSOR c_party_type(c_acct_id NUMBER) IS
1209: SELECT p.party_type