APPS.GMD_QCR02USR_XMLP_PKG dependencies on GEM_LOOKUPS

Line 667: GEM_LOOKUPS

663: SELECT
664: MEANING
665: INTO INCLUDE1
666: FROM
667: GEM_LOOKUPS
668: WHERE LOOKUP_CODE = '0'
669: AND LOOKUP_TYPE = 'QC_INCLUDE';
670: ELSIF INCLUDE = '1' THEN
671: SELECT

Line 675: GEM_LOOKUPS

671: SELECT
672: MEANING
673: INTO INCLUDE1
674: FROM
675: GEM_LOOKUPS
676: WHERE LOOKUP_CODE = '1'
677: AND LOOKUP_TYPE = 'QC_INCLUDE';
678: END IF;
679: RETURN (INCLUDE1);

Line 690: GEM_LOOKUPS

686: SELECT
687: MEANING
688: INTO PRINT1
689: FROM
690: GEM_LOOKUPS
691: WHERE LOOKUP_CODE = '0'
692: AND LOOKUP_TYPE = 'QC_PRINT';
693: ELSIF PRINT_CONDITION = '1' THEN
694: SELECT

Line 698: GEM_LOOKUPS

694: SELECT
695: MEANING
696: INTO PRINT1
697: FROM
698: GEM_LOOKUPS
699: WHERE LOOKUP_CODE = '1'
700: AND LOOKUP_TYPE = 'QC_PRINT';
701: ELSIF PRINT_CONDITION = '2' THEN
702: SELECT

Line 706: GEM_LOOKUPS

702: SELECT
703: MEANING
704: INTO PRINT1
705: FROM
706: GEM_LOOKUPS
707: WHERE LOOKUP_CODE = '2'
708: AND LOOKUP_TYPE = 'QC_PRINT';
709: ELSIF PRINT_CONDITION = '3' THEN
710: SELECT

Line 714: GEM_LOOKUPS

710: SELECT
711: MEANING
712: INTO PRINT1
713: FROM
714: GEM_LOOKUPS
715: WHERE LOOKUP_CODE = '3'
716: AND LOOKUP_TYPE = 'QC_PRINT';
717: END IF;
718: RETURN (PRINT1);