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 1174: FROM aso_quote_headers

1170: ,x_hd_tax_dtl_tbl IN OUT NOCOPY ASO_QUOTE_PUB.Tax_Detail_Tbl_Type) is
1171:
1172: CURSOR c_quote(c_party_id NUMBER, c_acct_id NUMBER) IS
1173: SELECT quote_header_id, creation_date, currency_code
1174: FROM aso_quote_headers
1175: WHERE quote_source_code = 'IStore Oneclick'
1176: and party_id = c_party_id
1177: and cust_account_id = c_acct_id
1178: and quote_name is null

Line 1198: FROM ASO_QUOTE_HEADERS

1194: and cust_account_id = c_acct_id;
1195:
1196: CURSOR c_quote_date(c_qte_header_id NUMBER) IS
1197: SELECT last_update_date
1198: FROM ASO_QUOTE_HEADERS
1199: WHERE quote_header_id = c_qte_header_id;
1200:
1201: CURSOR c_party_type(c_acct_id NUMBER) IS
1202: SELECT p.party_type