APPS.JE_JEFILPIP_XMLP_PKG dependencies on FND_LOOKUPS

Line 207: FND_LOOKUPS

203: SELECT
204: MEANING
205: INTO L_GROUP
206: FROM
207: FND_LOOKUPS
208: WHERE LOOKUP_TYPE = 'JEFI_LPIP_GROUP'
209: AND LOOKUP_CODE = P_GROUP_FIELD;
210: RETURN (L_GROUP);
211: EXCEPTION

Line 654: FND_LOOKUPS

650: SELECT
651: MEANING
652: INTO L_SUMMARY
653: FROM
654: FND_LOOKUPS
655: WHERE LOOKUP_TYPE = 'JEFI_LPIP_SUMMARY_LEVEL'
656: AND LOOKUP_CODE = P_SUMMARY_LEVEL;
657: C_SUMMARY_LEVEL := L_SUMMARY;
658: SELECT

Line 662: FND_LOOKUPS

658: SELECT
659: MEANING
660: INTO L_APPROVAL_STATUS
661: FROM
662: FND_LOOKUPS
663: WHERE LOOKUP_TYPE = 'JEFI_LPIP_APPROVAL_STATUS'
664: AND LOOKUP_CODE = NVL(P_MATCH_STATUS_FLAG
665: ,'*');
666: C_APPROVAL_STATUS := L_APPROVAL_STATUS;

Line 671: FND_LOOKUPS

667: SELECT
668: MEANING
669: INTO L_YES
670: FROM
671: FND_LOOKUPS
672: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
673: AND LOOKUP_CODE = 'Y';
674: C_YES := L_YES;
675: SELECT

Line 679: FND_LOOKUPS

675: SELECT
676: MEANING
677: INTO L_NO
678: FROM
679: FND_LOOKUPS
680: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
681: AND LOOKUP_CODE = 'N';
682: C_NO := L_NO;
683: SELECT

Line 687: FND_LOOKUPS

683: SELECT
684: MEANING
685: INTO L_ALL
686: FROM
687: FND_LOOKUPS
688: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
689: AND LOOKUP_CODE = 'A';
690: C_ALL := L_ALL;
691: RETURN (TRUE);

Line 701: A_FLAG FND_LOOKUPS.MEANING%TYPE;

697:
698: FUNCTION C_APPROVE_FLAGFORMULA(P_INVOICE_ID IN NUMBER) RETURN VARCHAR2 IS
699: BEGIN
700: DECLARE
701: A_FLAG FND_LOOKUPS.MEANING%TYPE;
702: A_COUNT NUMBER;
703: BEGIN
704: A_FLAG := C_NO;
705: A_COUNT := 0;