APPS.CAC_SYNC_CONTACTS_PVT dependencies on CAC_SYNC_CONTACT_TEMPS_S

Line 17: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,

13: b_bookmark_category VARCHAR2,
14: b_bookmark_preference VARCHAR2)
15:
16: IS
17: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,
18: HPP.VALUE_NUMBER REL_CONTACT_PARTY_ID
19: , ORG.PARTY_ID ORG_PARTY_ID
20: , ORG.PARTY_NAME ORG_NAME
21: , PERSON.PARTY_ID PERSON_PARTY_ID

Line 238: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID

234: b_bookmark_module VARCHAR2,
235: b_bookmark_category VARCHAR2,
236: b_bookmark_preference VARCHAR2)
237: IS
238: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID
239: , REL_CONTACT_PARTY_ID
240: , ORG_PARTY_ID
241: , ORG_NAME
242: , PERSON_PARTY_ID

Line 585: CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,

581: b_bookmark_preference VARCHAR2)
582:
583: IS
584: SELECT
585: CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,
586: CSUM.GUID REL_CONTACT_PARTY_ID,
587: -1 ORG_PARTY_ID,
588: NULL ORG_NAME,
589: -1 PERSON_PARTY_ID,

Line 630: IS SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID

626: b_bookmark_category VARCHAR2,
627: b_bookmark_preference VARCHAR2
628: )
629:
630: IS SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID
631: , HPP.VALUE_NUMBER REL_CONTACT_PARTY_ID
632: , ORG.PARTY_ID ORG_PARTY_ID
633: , ORG.PARTY_NAME ORG_NAME
634: , PERSON.PARTY_ID PERSON_PARTY_ID