APPS.GMD_QCR03USR_XMLP_PKG dependencies on GEM_LOOKUPS

Line 752: GEM_LOOKUPS

748: SELECT
749: MEANING
750: INTO INCLUDE1
751: FROM
752: GEM_LOOKUPS
753: WHERE LOOKUP_CODE = '0'
754: AND LOOKUP_TYPE = 'QC_INCLUDE';
755: ELSIF INCLUDE = '1' THEN
756: SELECT

Line 760: GEM_LOOKUPS

756: SELECT
757: MEANING
758: INTO INCLUDE1
759: FROM
760: GEM_LOOKUPS
761: WHERE LOOKUP_CODE = '1'
762: AND LOOKUP_TYPE = 'QC_INCLUDE';
763: END IF;
764: RETURN (INCLUDE1);

Line 774: GEM_LOOKUPS

770: SELECT
771: MEANING
772: INTO PRINT1
773: FROM
774: GEM_LOOKUPS
775: WHERE LOOKUP_CODE = '0'
776: AND LOOKUP_TYPE = 'QC_PRINT';
777: ELSIF PRINT_CONDITION = '1' THEN
778: SELECT

Line 782: GEM_LOOKUPS

778: SELECT
779: MEANING
780: INTO PRINT1
781: FROM
782: GEM_LOOKUPS
783: WHERE LOOKUP_CODE = '1'
784: AND LOOKUP_TYPE = 'QC_PRINT';
785: ELSIF PRINT_CONDITION = '2' THEN
786: SELECT

Line 790: GEM_LOOKUPS

786: SELECT
787: MEANING
788: INTO PRINT1
789: FROM
790: GEM_LOOKUPS
791: WHERE LOOKUP_CODE = '2'
792: AND LOOKUP_TYPE = 'QC_PRINT';
793: ELSIF PRINT_CONDITION = '3' THEN
794: SELECT

Line 798: GEM_LOOKUPS

794: SELECT
795: MEANING
796: INTO PRINT1
797: FROM
798: GEM_LOOKUPS
799: WHERE LOOKUP_CODE = '3'
800: AND LOOKUP_TYPE = 'QC_PRINT';
801: END IF;
802: RETURN (PRINT1);