667: ) IS
668:
669: CURSOR c1 IS
670: SELECT meaning
671: FROM gem_lookups
672: WHERE lookup_type = 'GMD_QC_FREQUENCY_PERIOD'
673: and lookup_code = p_time ;
674:
675: begin
1022: group by organization_id;
1023:
1024: CURSOR get_from_disp(p_change_disp_id IN NUMBER) IS
1025: select gl.meaning
1026: from gmd_change_disposition gcd ,gem_lookups gl
1027: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
1028: and gl.lookup_code = gcd.disposition_from
1029: and gcd.change_disp_id = p_change_disp_id;
1030:
1029: and gcd.change_disp_id = p_change_disp_id;
1030:
1031: CURSOR get_to_disp(p_change_disp_id IN NUMBER) IS
1032: select gl.meaning
1033: from gmd_change_disposition gcd ,gem_lookups gl
1034: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
1035: and gl.lookup_code = gcd.disposition_to
1036: and gcd.change_disp_id = p_change_disp_id;
1037: