DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on IBE_ACTIVE_QUOTES

Line 29: from ibe_active_quotes

25: CURSOR c_find_active_cart(c_quote_header_id NUMBER,
26: c_party_id NUMBER,
27: c_cust_account_id NUMBER) is
28: select quote_header_id
29: from ibe_active_quotes
30: where quote_header_id = c_quote_header_id
31: and party_id = c_party_id
32: and cust_account_id = c_cust_account_id
33: and record_type = 'CART';

Line 153: FROM IBE_ACTIVE_QUOTES AQ

149: --active_quotes table(single source of truth for active quotes)
150:
151: SELECT aq.quote_header_id
152: INTO l_quote_header_id
153: FROM IBE_ACTIVE_QUOTES AQ
154: where party_id = p_party_id
155: and cust_account_id = p_cust_account_id
156: and record_type = 'CART';
157:

Line 4083: from ibe_active_quotes

4079: CURSOR c_get_active_cart(c_quote_header_id NUMBER,
4080: c_party_id NUMBER,
4081: c_cust_account_id NUMBER) is
4082: select quote_header_id
4083: from ibe_active_quotes
4084: where quote_header_id = c_quote_header_id
4085: and party_id = c_party_id
4086: and cust_account_id = c_cust_account_id
4087: and record_type = 'CART';