DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on GEM_LOOKUPS

Line 671: FROM gem_lookups

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

Line 1026: from gmd_change_disposition gcd ,gem_lookups gl

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:

Line 1033: from gmd_change_disposition gcd ,gem_lookups gl

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: