APPS.CAC_SYNC_CONTACTS_PVT dependencies on CAC_SYNC_MAPPINGS

Line 200: FROM CAC_SYNC_MAPPINGS

196: AND C.CONTACT_POINT_TYPE = 'EMAIL'
197: AND C.STATUS = 'A')
198: ) CPT_EMAIL
199: WHERE NOT EXISTS (SELECT NULL
200: FROM CAC_SYNC_MAPPINGS
201: WHERE GUID = HPP.VALUE_NUMBER
202: AND PRINCIPAL_ID = b_principal_id
203: AND SERVER_URI = SERVER_URI_CONST)
204: AND HPP.CATEGORY = b_bookmark_category

Line 546: FROM CAC_SYNC_MAPPINGS

542: AND HPP.CATEGORY = b_bookmark_category
543: AND HPP.PREFERENCE_CODE = b_bookmark_preference
544: AND HPP.MODULE = b_bookmark_module
545: AND EXISTS (SELECT NULL
546: FROM CAC_SYNC_MAPPINGS
547: WHERE GUID = HPP.VALUE_NUMBER
548: AND PRINCIPAL_ID = b_principal_id
549: AND SERVER_URI = SERVER_URI_CONST)
550: AND REL_CONTACT.PARTY_ID = HPP.VALUE_NUMBER

Line 610: FROM CAC_SYNC_MAPPINGS CSUM

606: NULL CELL_PHONE_CONTACT_POINT_ID,
607: NULL PAGER_CONTACT_POINT_ID,
608: NULL EMAIL_CONTACT_POINT_ID,
609: 'D' STATUS
610: FROM CAC_SYNC_MAPPINGS CSUM
611: WHERE NOT EXISTS (SELECT NULL
612: FROM HZ_PARTY_PREFERENCES
613: WHERE VALUE_NUMBER = CSUM.GUID
614: AND CATEGORY = b_bookmark_category