APPS.CZ_IMP_ALL dependencies on CZ_EXV_ORGANIZATIONS

Line 837: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

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

Line 884: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

880: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
881:
882: 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;
883:
884: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
885: WHERE ORGANIZATION_CODE = sOrg_ID;
886:
887: OPEN C_GETMODELS(nOrg_ID);
888: LOOP

Line 955: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

951: CZ_ORAAPPS_INTEGRATE.mRETCODE := 0;
952:
953: 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;
954:
955: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
956: WHERE ORGANIZATION_CODE = sOrg_ID;
957:
958: OPEN C_GETMODELS(nOrg_ID);
959: LOOP