[Home] [Help]
54: AND ORG_CONT.ORG_CONTACT_ID = c_contact_id
55: AND PARTY.PARTY_ID = P_CUSTOMER_ID;
56: */
57:
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,
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
67: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
68: AND REL.OBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = PARTY2.PARTY_ID
69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
139: )
140: IS
141: CURSOR C_CONTACT_PARTY_ID_Exists (c_CONTACT_PARTY_ID NUMBER) IS
142: Select 'X'
143: from hz_relationships
144: where party_id = c_CONTACT_PARTY_ID
145: and object_id = P_CUSTOMER_ID
146: and subject_table_name = 'HZ_PARTIES'
147: and object_table_name = 'HZ_PARTIES' --;
148: --and relationship_code = 'CONTACT_OF';
149: -- ffang 100901, bug 2039435, add checking on status
150: AND STATUS IN ('A', 'I');
151:
152: /* ffang 083001, use hz_relationships instead of hz_party_relationships
153: SELECT 'X'
154: FROM HZ_PARTY_RELATIONSHIPS
155: WHERE object_id = P_CUSTOMER_ID
156: AND party_id = c_CONTACT_PARTY_ID;
561: IS
562: -- for bug 2098158 ckapoor - change cursor to retrieve the phone and party id of contact also
563: Cursor C_Get_Primary_Contact ( c_SALES_LEAD_ID NUMBER ) IS
564: SELECT slc.LEAD_CONTACT_ID, slc.CONTACT_PARTY_ID, slc.PHONE_ID, r.subject_id
565: FROM as_sales_lead_contacts slc, hz_relationships r
566: WHERE slc.sales_lead_id = c_SALES_LEAD_ID
567: and slc.enabled_flag = 'Y'
568: and slc.primary_contact_flag = 'Y'
569: and r.party_id = slc.contact_party_id
1050:
1051: -- for bug 2098158 ckapoor - change cursor to retrieve the phone and party id of contact also
1052: Cursor C_Get_Pri_Contact ( c_SALES_LEAD_ID NUMBER ) IS
1053: SELECT slc.CONTACT_PARTY_ID, slc.PHONE_ID, r.subject_id
1054: FROM as_sales_lead_contacts slc, hz_relationships r
1055: WHERE slc.sales_lead_id = c_SALES_LEAD_ID
1056: and slc.enabled_flag = 'Y'
1057: and slc.primary_contact_flag = 'Y'
1058: and r.party_id = slc.contact_party_id