APPS.CZ_IMP_ALL dependencies on CZ_EXV_ORGANIZATIONS

Line 834: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

830: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
831: RAISE;
832: END;
833:
834: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
835: WHERE ORGANIZATION_CODE = sOrg_ID;
836:
837: SELECT inventory_item_id INTO nTop_ID
838: FROM cz_exv_mtl_system_items

Line 881: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

877: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
878:
879: SELECT DECODE(COPY_CHILD_MODELS,'Y','0','N','1','YES','0','NO','1','TRUE','0','FALSE','1','T','0','F','1','1','1','0') into v_copy_child_models from dual;
880:
881: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
882: WHERE ORGANIZATION_CODE = sOrg_ID;
883:
884: OPEN C_GETMODELS(nOrg_ID);
885: LOOP