APPS.PMI_PRODUCTION_SUM dependencies on GMD_SAMPLES

Line 310: select count(*) into NO_OF_SAMPLES_v from GMD_SAMPLES

306: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V1 then
307: return PKG_VAR_NO_OF_SAMPLES_V;
308: end if;
309:
310: select count(*) into NO_OF_SAMPLES_v from GMD_SAMPLES
311: where batch_id = BATCH_ID_VI;
312:
313: PKG_VAR_BATCH_ID_V1 := BATCH_ID_vi;
314: PKG_VAR_NO_OF_SAMPLES_V := NO_OF_SAMPLES_v;

Line 328: from GMD_SAMPLES Smp,

324: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V4 then
325: return PKG_VAR_NO_OF_SMPL_CMPLT_V;
326: end if;
327: Select count(*) into COMPLET_SAMPLES_v
328: from GMD_SAMPLES Smp,
329: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,
330: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP
331: WHERE SMP.SAMPLING_EVENT_ID = EVT_SPEC_DISP.SAMPLING_EVENT_ID
332: AND EVT_SPEC_DISP.EVENT_SPEC_DISP_ID = SMP_SPEC_DISP.EVENT_SPEC_DISP_ID

Line 352: from GMD_SAMPLES Smp,

348: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V2 then
349: return PKG_VAR_PASSED_SAMPLES_V;
350: end if;
351: Select count(*) into PASSED_SAMPLES_V
352: from GMD_SAMPLES Smp,
353: GMD_EVENT_SPEC_DISP EVT_SPEC_DISP,
354: GMD_SAMPLE_SPEC_DISP SMP_SPEC_DISP
355: WHERE SMP.SAMPLING_EVENT_ID = EVT_SPEC_DISP.SAMPLING_EVENT_ID
356: AND EVT_SPEC_DISP.EVENT_SPEC_DISP_ID = SMP_SPEC_DISP.EVENT_SPEC_DISP_ID