APPS.CZ_IMP_AC_KRS dependencies on CZ_ADDRESS_USES

Line 655: SELECT address_use_id FROM CZ_ADDRESS_USES WHERE orig_sys_ref=sImpOrigSysRef;

651:
652: /* Check the online database */
653: DECLARE
654: CURSOR c_onl_address_uses IS
655: SELECT address_use_id FROM CZ_ADDRESS_USES WHERE orig_sys_ref=sImpOrigSysRef;
656: BEGIN
657: OPEN c_onl_address_uses;
658: nOnladdressusesId:=NULL;
659: FETCH c_onl_address_uses INTO nOnladdressusesId;

Line 711: SELECT CZ_ADDRESS_USES_S.NEXTVAL INTO nNextValue FROM DUAL;

707: nInsertCount:=nInsertCount+1;
708: nAllocateCounter:=nAllocateCounter+1;
709: IF(nAllocateCounter=nAllocateBlock)THEN
710: nAllocateCounter:=0;
711: SELECT CZ_ADDRESS_USES_S.NEXTVAL INTO nNextValue FROM DUAL;
712: END IF;
713: END IF;
714: END;
715: END IF;