APPS.IBE_ONECLK_PVT dependencies on ASO_QUOTE_HEADERS

Line 54: FROM aso_quote_headers h

50: h.total_quote_price,
51: h.party_id,
52: h.cust_account_id,
53: h.org_id
54: FROM aso_quote_headers h
55: WHERE
56: trunc(h.quote_expiration_date) >= trunc(sysdate) and
57: h.quote_source_code = 'IStore Oneclick' and
58: h.order_id is null and

Line 70: from aso_quote_headers_all a, aso_quote_statuses_vl b

66: cust_account_id = c_acct_id;
67:
68: CURSOR c_quote_status_code (quote_hdr_id number) is
69: select status_code
70: from aso_quote_headers_all a, aso_quote_statuses_vl b
71: where quote_header_id = quote_hdr_id
72: and a.quote_status_id = b.quote_status_id;
73:
74: rec_quote_status_code c_quote_status_code%rowtype;