DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_PVT dependencies on HZ_CONTACT_POINTS

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