APPS.GMD_QCR01USR_XMLP_PKG dependencies on GEM_LOOKUPS

Line 608: GEM_LOOKUPS

604: SELECT
605: MEANING
606: INTO CUSTVENDTITLE
607: FROM
608: GEM_LOOKUPS
609: WHERE LOOKUP_TYPE = 'GMD_REPORT_TYPE'
610: AND LOOKUP_CODE = REPORT_TYPE;
611: RETURN (CUSTVENDTITLE);
612: END CUST_VENDCFFORMULA;

Line 748: GEM_LOOKUPS

744: SELECT
745: MEANING
746: INTO INCLUDE1
747: FROM
748: GEM_LOOKUPS
749: WHERE LOOKUP_CODE = '0'
750: AND LOOKUP_TYPE = 'QC_INCLUDE';
751: ELSIF INCLUDE = '1' THEN
752: SELECT

Line 756: GEM_LOOKUPS

752: SELECT
753: MEANING
754: INTO INCLUDE1
755: FROM
756: GEM_LOOKUPS
757: WHERE LOOKUP_CODE = '1'
758: AND LOOKUP_TYPE = 'QC_INCLUDE';
759: END IF;
760: RETURN (INCLUDE1);

Line 770: GEM_LOOKUPS

766: SELECT
767: MEANING
768: INTO PRINT1
769: FROM
770: GEM_LOOKUPS
771: WHERE LOOKUP_CODE = '0'
772: AND LOOKUP_TYPE = 'QC_PRINT';
773: ELSIF PRINT_CONDITION = '1' THEN
774: SELECT

Line 778: GEM_LOOKUPS

774: SELECT
775: MEANING
776: INTO PRINT1
777: FROM
778: GEM_LOOKUPS
779: WHERE LOOKUP_CODE = '1'
780: AND LOOKUP_TYPE = 'QC_PRINT';
781: ELSIF PRINT_CONDITION = '2' THEN
782: SELECT

Line 786: GEM_LOOKUPS

782: SELECT
783: MEANING
784: INTO PRINT1
785: FROM
786: GEM_LOOKUPS
787: WHERE LOOKUP_CODE = '2'
788: AND LOOKUP_TYPE = 'QC_PRINT';
789: ELSIF PRINT_CONDITION = '3' THEN
790: SELECT

Line 794: GEM_LOOKUPS

790: SELECT
791: MEANING
792: INTO PRINT1
793: FROM
794: GEM_LOOKUPS
795: WHERE LOOKUP_CODE = '3'
796: AND LOOKUP_TYPE = 'QC_PRINT';
797: END IF;
798: RETURN (PRINT1);