APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on HZ_ORG_CONTACTS

Line 230: , HZ_ORG_CONTACTS ORCT

226: IS
227: CURSOR c_ctx (b_search_context_id NUMBER) IS
228: SELECT REL.PARTY_ID
229: FROM HZ_RELATIONSHIPS REL
230: , HZ_ORG_CONTACTS ORCT
231: , HZ_MATCHED_CONTACTS_GT GT
232: WHERE REL.RELATIONSHIP_ID = ORCT.PARTY_RELATIONSHIP_ID
233: AND REL.DIRECTIONAL_FLAG = 'F'
234: AND ORCT.ORG_CONTACT_ID = GT.ORG_CONTACT_ID