APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_QC_TEST_VALUES

Line 380: FROM gmd_qc_test_values

376: --Added above and r.delete_mark = 0 condition
377: CURSOR c_get_range_with_disp(p_test_id NUMBER,
378: p_result NUMBER) IS
379: SELECT display_label_numeric_range
380: FROM gmd_qc_test_values
381: WHERE p_result between min_num and max_num
382: AND test_id = p_test_id;
383:
384: BEGIN

Line 537: FROM gmd_qc_test_values

533:
534: CURSOR c_get_range_with_disp(p_test_id NUMBER,
535: p_result NUMBER) IS
536: SELECT display_label_numeric_range
537: FROM gmd_qc_test_values
538: WHERE p_result between min_num and max_num
539: AND test_id = p_test_id;
540:
541: l_get_cust_test c_get_cust_test%ROWTYPE;

Line 659: FROM gmd_qc_test_values

655: -- B9646741 Added NVL
656: CURSOR c_get_range_with_disp(p_test_id NUMBER,
657: p_value NUMBER) IS
658: SELECT display_label_numeric_range
659: FROM gmd_qc_test_values
660: WHERE nvl(p_value,nvl(min_num,max_num)) between nvl(min_num,nvl(p_value,max_num)) and nvl(max_num,nvl(p_value,min_num))
661: AND test_id = p_test_id;
662: l_text VARCHAR2(240);
663: BEGIN