APPS.XTR_XTRCCYGL_XMLP_PKG dependencies on FND_LOOKUPS

Line 28: FND_LOOKUPS

24: INTO
25: L_FACTOR
26: ,P_USER_FACTOR
27: FROM
28: FND_LOOKUPS
29: WHERE LOOKUP_TYPE = 'XTR_FACTOR'
30: AND LOOKUP_CODE = SUBSTR(P_FACTOR
31: ,1
32: ,1);

Line 49: FND_LOOKUPS

45: MEANING
46: INTO
47: Z2REALIZED_FLAG
48: FROM
49: FND_LOOKUPS
50: WHERE LOOKUP_TYPE = 'XTR_MISC'
51: --AND LOOKUP_CODE = P_REALIZED_FLAG;
52: AND LOOKUP_CODE = P_REALIZED_FLAG_T;
53: IF P_REALIZED_FLAG_T = 'REAL' THEN

Line 80: FND_LOOKUPS

76: MEANING
77: INTO
78: P_USER_DEAL_TYPE
79: FROM
80: FND_LOOKUPS
81: WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
82: AND LOOKUP_CODE = 'HEDGE';
83: END IF;
84: EXCEPTION

Line 95: FND_LOOKUPS

91: MEANING
92: INTO
93: P_USER_GROUPBY
94: FROM
95: FND_LOOKUPS
96: WHERE LOOKUP_TYPE = 'XTR_MISC'
97: AND LOOKUP_CODE = P_GROUPBY;
98: END IF;
99: EXCEPTION

Line 326: FND_LOOKUPS

322: ,30)
323: INTO
324: L_USER_DEAL_SUBTYPE
325: FROM
326: FND_LOOKUPS
327: WHERE LOOKUP_TYPE = 'XTR_HEDGE_TYPES'
328: AND LOOKUP_CODE = DEAL_SUBTYPE_p;
329: END IF;
330: RETURN (L_USER_DEAL_SUBTYPE);

Line 357: FND_LOOKUPS

353: ,30)
354: INTO
355: L_USER_DEAL_TYPE
356: FROM
357: FND_LOOKUPS
358: WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
359: AND LOOKUP_CODE = 'HEDGE';
360: END IF;
361: RETURN (L_USER_DEAL_TYPE);