APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on HZ_CONTACT_POINTS

Line 1443: From hz_contact_points

1439: Cursor c_getContactInfo(c_owner_table_id Number
1440: ,c_contact_point_type varchar2
1441: ,c_owner_table_name varchar2) IS
1442: Select contact_point_id, object_version_number
1443: From hz_contact_points
1444: Where OWNER_TABLE_NAME = c_owner_table_name
1445: AND CONTACT_POINT_TYPE = c_CONTACT_POINT_TYPE
1446: AND OWNER_TABLE_ID = c_owner_table_id;
1447:

Line 1500: FROM hz_contact_points

1496:
1497:
1498: SELECT COUNT(contact_point_id)
1499: INTO l_test
1500: FROM hz_contact_points
1501: WHERE owner_table_name = l_contact_points_rec.owner_table_name
1502: AND owner_table_id = l_contact_points_rec.owner_table_id;
1503:
1504: IF l_test = 0 THEN

Line 2014: HZ_CONTACT_POINTS HZ,

2010: quote_sharee_number,
2011: HZ.EMAIL_ADDRESS,
2012: FND.customer_id shared_by_party_id
2013: from IBE_SH_QUOTE_ACCESS SH,
2014: HZ_CONTACT_POINTS HZ,
2015: FND_USER FND
2016: where SH.contact_point_id = HZ.Contact_point_id
2017: and quote_header_id = c_qte_hdr_id
2018: and nvl(end_date_active, sysdate+1) > sysdate

Line 2030: HZ_CONTACT_POINTS HZ,

2026: quote_sharee_number,
2027: HZ.EMAIL_ADDRESS,
2028: FND.customer_id shared_by_party_id
2029: from IBE_SH_QUOTE_ACCESS SH,
2030: HZ_CONTACT_POINTS HZ,
2031: FND_USER FND
2032: where SH.contact_point_id = HZ.Contact_point_id
2033: and quote_sharee_id = c_recipient_id
2034: and nvl(end_date_active, sysdate+1) > sysdate

Line 2691: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS

2687: where quote_header_id = c_quote_id;
2688:
2689: cursor c_get_contact_point_ovn(c_quote_sharee_id Number) IS
2690: select QUOTE_ACCESS.party_id, CNTCT_POINTS.contact_point_id, CNTCT_POINTS.object_version_number
2691: from hz_contact_points CNTCT_POINTS, ibe_sh_quote_access QUOTE_ACCESS
2692: where CNTCT_POINTS.contact_point_id = QUOTE_ACCESS.contact_point_id
2693: and quote_sharee_id = c_quote_sharee_id;
2694:
2695: rec_find_active_cart c_find_active_cart%rowtype;