DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACT_DQM_PVT dependencies on HZ_MATCHED_CONTACTS_GT

Line 231: , HZ_MATCHED_CONTACTS_GT GT

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
235: AND GT.SEARCH_CONTEXT_ID = b_search_context_id;