APPS.XTR_XTRREVGL_XMLP_PKG dependencies on FND_LOOKUPS

Line 107: FND_LOOKUPS

103: ,100000000),
104: MEANING
105: INTO L_FACTOR,P_USER_FACTOR
106: FROM
107: FND_LOOKUPS
108: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
109: AND LOOKUP_CODE = SUBSTR(P_FACTOR
110: ,1
111: ,1);

Line 126: FND_LOOKUPS

122: SELECT
123: MEANING
124: INTO Z2REALIZED_FLAG
125: FROM
126: FND_LOOKUPS
127: WHERE LOOKUP_TYPE = 'XTR_MISC'
128: AND LOOKUP_CODE = P_REALIZED_FLAG;
129:
130: IF P_REALIZED_FLAG = 'REAL' THEN

Line 155: FND_LOOKUPS

151: SELECT
152: MEANING
153: INTO P_USER_DEAL_TYPE
154: FROM
155: FND_LOOKUPS
156: WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
157: AND LOOKUP_CODE = 'HEDGE';
158: END IF;
159: EXCEPTION

Line 169: FND_LOOKUPS

165: SELECT
166: MEANING
167: INTO P_USER_GROUPBY
168: FROM
169: FND_LOOKUPS
170: WHERE LOOKUP_TYPE = 'XTR_MISC'
171: AND LOOKUP_CODE = P_GROUPBY;
172: END IF;
173: EXCEPTION

Line 399: FND_LOOKUPS

395: ,1
396: ,30)
397: INTO L_USER_DEAL_SUBTYPE
398: FROM
399: FND_LOOKUPS
400: WHERE LOOKUP_TYPE = 'XTR_HEDGE_TYPES'
401: AND LOOKUP_CODE = DEAL_SUBTYPE_1;
402: END IF;
403: RETURN (L_USER_DEAL_SUBTYPE);

Line 426: FND_LOOKUPS

422: SELECT
423: MEANING
424: INTO L_USER_DEAL_TYPE
425: FROM
426: FND_LOOKUPS
427: WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
428: AND LOOKUP_CODE = 'HEDGE';
429: END IF;
430: RETURN (L_USER_DEAL_TYPE);