APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_RESULTS

Line 1254: FROM GMD_SAMPLES gs , GMD_RESULTS gr

1250: AND gst.optional_ind is NULL ;
1251:
1252: CURSOR cr_get_sample_for_lot IS
1253: SELECT nvl(gs.lot_number,-1), gs.sample_id,gr.test_id,gr.result_value_num,gr.result_value_char -- 9744927 added nvl(gs.lot_number,-1)
1254: FROM GMD_SAMPLES gs , GMD_RESULTS gr
1255: WHERE gs.sample_id = gr.sample_id
1256: AND gs.delete_mark = 0
1257: AND gs.sample_id IN ( SELECT ssd.sample_id FROM gmd_sample_spec_disp ssd
1258: WHERE ssd.sample_id = gs.sample_id

Line 1396: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(

1392: -- check test results against the selected sample are in range as per the given specification
1393: l_spec_test_counter := spec_test_list.FIRST;
1394: WHILE l_spec_test_counter IS NOT NULL
1395: LOOP
1396: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(
1397: p_spec_id => p_spec_id
1398: , p_test_id => spec_test_list(l_spec_test_counter)
1399: , p_rslt_value_num => result_test_list(l_spec_test_counter).result_value_num
1400: , p_rslt_value_char => result_test_list(l_spec_test_counter).result_value_char ) ;