APPS.CZ_IMP_AC_KRS dependencies on CZ_CONTACTS

Line 90: SELECT CONTACT_ID FROM CZ_CONTACTS WHERE ORIG_SYS_REF=sImpOrigsysref;

86: EXIT WHEN NOT x_imp_contact_f;
87: /* Check Online Dbase */
88: DECLARE
89: CURSOR c_onl_contact IS
90: SELECT CONTACT_ID FROM CZ_CONTACTS WHERE ORIG_SYS_REF=sImpOrigsysref;
91: BEGIN
92: OPEN c_onl_contact;
93: nOnlContactId:=NULL;
94: FETCH c_onl_contact INTO nOnlContactId;

Line 165: SELECT CZ_CONTACTS_S.NEXTVAL INTO nNextValue FROM DUAL;

161: nInsertCount:=nInsertCount+1;
162: nAllocateCounter:=nAllocateCounter+1;
163: IF(nAllocateCounter=nAllocateBlock)THEN
164: nAllocateCounter:=0;
165: SELECT CZ_CONTACTS_S.NEXTVAL INTO nNextValue FROM DUAL;
166: END IF;
167: END IF;
168: END;
169: END IF;