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 989: from gmd_change_disposition gcd ,gem_lookups gl

985: group by organization_id;
986:
987: CURSOR get_from_disp(p_change_disp_id IN NUMBER) IS
988: select gl.meaning
989: from gmd_change_disposition gcd ,gem_lookups gl
990: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
991: and gl.lookup_code = gcd.disposition_from
992: and gcd.change_disp_id = p_change_disp_id;
993:

Line 996: from gmd_change_disposition gcd ,gem_lookups gl

992: and gcd.change_disp_id = p_change_disp_id;
993:
994: CURSOR get_to_disp(p_change_disp_id IN NUMBER) IS
995: select gl.meaning
996: from gmd_change_disposition gcd ,gem_lookups gl
997: where gl.lookup_type = 'GMD_QC_SAMPLE_DISP'
998: and gl.lookup_code = gcd.disposition_to
999: and gcd.change_disp_id = p_change_disp_id;
1000: