DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_PVT dependencies on IBE_SH_QUOTE_ACCESS

Line 17: from ibe_sh_quote_access

13: l_true VARCHAR2(1) := FND_API.G_TRUE;
14:
15: cursor c_is_shared_cart(c_qte_hdr_id NUMBER) is
16: select count(*) yes_shared_cart
17: from ibe_sh_quote_access
18: where quote_header_id = c_qte_hdr_id
19: and nvl(end_date_active,sysdate+1) > sysdate;
20:
21: rec_is_shared_cart c_is_shared_cart%rowtype;

Line 536: from ibe_sh_quote_access

532: := IBE_QUOTE_SAVESHARE_pvt.g_miss_quote_access_tbl;
533:
534: cursor c_get_sharee_id is
535: select quote_sharee_number
536: from ibe_sh_quote_access
537: where quote_sharee_id = (select max(quote_sharee_id)
538: from ibe_sh_quote_access I, hz_contact_points h
539: where i.contact_point_id = h.contact_point_id
540: and upper(h.owner_table_name) = 'IBE_SH_QUOTE_ACCESS'

Line 538: from ibe_sh_quote_access I, hz_contact_points h

534: cursor c_get_sharee_id is
535: select quote_sharee_number
536: from ibe_sh_quote_access
537: where quote_sharee_id = (select max(quote_sharee_id)
538: from ibe_sh_quote_access I, hz_contact_points h
539: where i.contact_point_id = h.contact_point_id
540: and upper(h.owner_table_name) = 'IBE_SH_QUOTE_ACCESS'
541: and UPPER(h.email_address) = upper(p_emailaddress)
542: and quote_header_id = p_quote_header_id

Line 540: and upper(h.owner_table_name) = 'IBE_SH_QUOTE_ACCESS'

536: from ibe_sh_quote_access
537: where quote_sharee_id = (select max(quote_sharee_id)
538: from ibe_sh_quote_access I, hz_contact_points h
539: where i.contact_point_id = h.contact_point_id
540: and upper(h.owner_table_name) = 'IBE_SH_QUOTE_ACCESS'
541: and UPPER(h.email_address) = upper(p_emailaddress)
542: and quote_header_id = p_quote_header_id
543: and i.update_privilege_type_code = p_privilegeType);
544:

Line 2123: from ibe_sh_quote_access

2119: cursor c_get_retrieval_num(c_party_id number,
2120: c_cust_account_id number,
2121: c_quote_header_id number) is
2122: select quote_sharee_number
2123: from ibe_sh_quote_access
2124: where quote_header_id = c_quote_header_id
2125: and party_id = c_party_id
2126: and cust_account_id = c_cust_account_id;
2127: