APPS.JG_JGZZSRCR_XMLP_PKG dependencies on FND_LOOKUPS

Line 229: FND_LOOKUPS

225: SELECT
226: MEANING
227: INTO L_GROUP
228: FROM
229: FND_LOOKUPS
230: WHERE LOOKUP_TYPE = 'JGZZ_AP_INVOICE_GROUP'
231: AND LOOKUP_CODE = P_GROUP_FIELD;
232: RETURN (L_GROUP);
233: EXCEPTION

Line 683: FND_LOOKUPS

679: SELECT
680: MEANING
681: INTO L_SUMMARY
682: FROM
683: FND_LOOKUPS
684: WHERE LOOKUP_TYPE = 'JGZZ_AP_SUMMARY_LEVEL'
685: AND LOOKUP_CODE = P_SUMMARY_LEVEL;
686: C_SUMMARY_LEVEL := L_SUMMARY;
687: SELECT

Line 691: FND_LOOKUPS

687: SELECT
688: MEANING
689: INTO L_APPROVAL_STATUS
690: FROM
691: FND_LOOKUPS
692: WHERE LOOKUP_TYPE = 'JGZZ_INVOICE_VALIDATION_STATUS'
693: AND LOOKUP_CODE = NVL(P_MATCH_STATUS_FLAG_V
694: ,'*');
695: C_APPROVAL_STATUS := L_APPROVAL_STATUS;

Line 703: FND_LOOKUPS

699: SELECT
700: MEANING
701: INTO L_YES
702: FROM
703: FND_LOOKUPS
704: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
705: AND LOOKUP_CODE = 'Y';
706: C_YES := L_YES;
707: SELECT

Line 711: FND_LOOKUPS

707: SELECT
708: MEANING
709: INTO L_NO
710: FROM
711: FND_LOOKUPS
712: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
713: AND LOOKUP_CODE = 'N';
714: C_NO := L_NO;
715: SELECT

Line 719: FND_LOOKUPS

715: SELECT
716: MEANING
717: INTO L_ALL
718: FROM
719: FND_LOOKUPS
720: WHERE LOOKUP_TYPE = 'YES_NO_ALL'
721: AND LOOKUP_CODE = 'A';
722: C_ALL := L_ALL;
723: RETURN (TRUE);

Line 733: A_FLAG FND_LOOKUPS.MEANING%TYPE;

729:
730: FUNCTION C_APPROVE_FLAGFORMULA(INVOICE_ID_v IN NUMBER) RETURN VARCHAR2 IS
731: BEGIN
732: DECLARE
733: A_FLAG FND_LOOKUPS.MEANING%TYPE;
734: A_COUNT NUMBER;
735: BEGIN
736: A_FLAG := C_NO;
737: A_COUNT := 0;

Line 821: FND_LOOKUPS

817: SELECT
818: MEANING
819: INTO L_GROUP
820: FROM
821: FND_LOOKUPS
822: WHERE LOOKUP_TYPE = 'JGZZ_AP_INVOICE_GROUP'
823: AND LOOKUP_CODE = P_GROUP_FIELD;
824: RETURN (L_GROUP);
825: EXCEPTION