APPS.AS_SALES_LEAD_CONTACTS_PVT dependencies on HZ_CONTACT_POINTS

Line 43: FROM HZ_CONTACT_POINTS CONT_POINT,

39: -- solin, 02/01/2001, replace view AS_PARTY_ORG_CONTACTS_V with HZ tables
40: /*
41: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
42: SELECT 'X'
43: FROM HZ_CONTACT_POINTS CONT_POINT,
44: HZ_PARTIES PARTY,
45: HZ_PARTIES PARTY2,
46: HZ_PARTY_RELATIONSHIPS REL,
47: HZ_ORG_CONTACTS ORG_CONT

Line 62: FROM -- HZ_CONTACT_POINTS CONT_POINT,

58: -- ffang 100401, bug 2031450, HZ_RELATIONSHIPS should be used to replace
59: -- HZ_PARTY_RELATIONSHIPS
60: CURSOR C_CONTACT_ID_Exists(c_contact_id NUMBER) IS
61: SELECT 'X'
62: FROM -- HZ_CONTACT_POINTS CONT_POINT,
63: HZ_PARTIES PARTY,
64: HZ_PARTIES PARTY2,
65: HZ_RELATIONSHIPS REL,
66: HZ_ORG_CONTACTS ORG_CONT

Line 255: -- ffang012501, use HZ_CONTACT_POINTS instead of AS_PARTY_PHONES_V

251: X_Msg_Count OUT NOCOPY NUMBER,
252: X_Msg_Data OUT NOCOPY VARCHAR2
253: )
254: IS
255: -- ffang012501, use HZ_CONTACT_POINTS instead of AS_PARTY_PHONES_V
256: CURSOR C_PHONE_ID_Exists(c_phone_id NUMBER) IS
257: SELECT 'X'
258: FROM HZ_CONTACT_POINTS
259: WHERE contact_point_id = c_phone_id

Line 258: FROM HZ_CONTACT_POINTS

254: IS
255: -- ffang012501, use HZ_CONTACT_POINTS instead of AS_PARTY_PHONES_V
256: CURSOR C_PHONE_ID_Exists(c_phone_id NUMBER) IS
257: SELECT 'X'
258: FROM HZ_CONTACT_POINTS
259: WHERE contact_point_id = c_phone_id
260: AND owner_table_name = 'HZ_PARTIES'
261: AND owner_table_id = P_CONTACT_PARTY_ID
262: AND CONTACT_POINT_TYPE IN ( 'PHONE', 'FAX') --;