APPS.GMD_QCR03USR_XMLP_PKG dependencies on GMD_QC_TESTS

Line 232: GMD_QC_TESTS

228: SELECT
229: '[' || TEST_DESC || ']'
230: INTO ASSAYDESC
231: FROM
232: GMD_QC_TESTS
233: WHERE TEST_CODE = ASSAY_CODE;
234: RETURN (ASSAYDESC);
235: EXCEPTION
236: WHEN OTHERS THEN

Line 286: GMD_QC_TESTS_B

282: SELECT
283: TEST_UNIT
284: INTO QCUNIT
285: FROM
286: GMD_QC_TESTS_B
287: WHERE TEST_CODE = ASSAY_CODE;
288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
290: RETURN (NULL);

Line 298: GMD_QC_TESTS

294: SELECT
295: TEST_UNIT
296: INTO QCUNIT
297: FROM
298: GMD_QC_TESTS
299: WHERE TEST_ID = QCASSY_TYP_ID;
300: END;
301: RETURN (QCUNIT);
302: END IF;

Line 734: GMD_QC_TESTS_B GT

730: GR1.TEXT_CODE
731: INTO TEXTCODE
732: FROM
733: GMD_RESULTS GR1,
734: GMD_QC_TESTS_B GT
735: WHERE GR1.RESULT_ID = QC_RESULT_ID
736: AND GR1.TEST_ID = GT.TEST_ID
737: AND GT.TEST_CODE = ASSAY_CODE;
738: RETURN (TEXTCODE);

Line 929: GMD_QC_TESTS_B

925: DISTINCT
926: TEST_TYPE
927: INTO ASSAYTYPE
928: FROM
929: GMD_QC_TESTS_B
930: WHERE TEST_CODE = ASSAY_CODE;
931: EXCEPTION
932: WHEN NO_DATA_FOUND THEN
933: NULL;