APPS.XTR_XTRDDHTY_XMLP_PKG dependencies on FND_LOOKUPS

Line 116: FND_LOOKUPS

112: CURSOR CUR_MEAN(P_TYPE IN VARCHAR2,P_CODE IN VARCHAR2) IS
113: SELECT
114: MEANING
115: FROM
116: FND_LOOKUPS
117: WHERE LOOKUP_TYPE = P_TYPE
118: AND LOOKUP_CODE = P_CODE;
119: L_LOOKUP_TYPE VARCHAR2(30);
120: BEGIN

Line 375: FND_LOOKUPS

371: CURSOR HTYPE(P_HTYPE IN VARCHAR2) IS
372: SELECT
373: MEANING
374: FROM
375: FND_LOOKUPS
376: WHERE LOOKUP_TYPE = 'XTR_HEDGE_TYPES'
377: AND LOOKUP_CODE = P_HTYPE;
378: L_HEDGE_TYPE VARCHAR2(80);
379: BEGIN

Line 397: FND_LOOKUPS

393: CURSOR OBJ(P_OBJ IN VARCHAR2) IS
394: SELECT
395: MEANING
396: FROM
397: FND_LOOKUPS
398: WHERE LOOKUP_TYPE = 'XTR_HEDGE_OBJECTIVE_TYPES'
399: AND LOOKUP_CODE = P_OBJ;
400: L_OBJNAME VARCHAR2(80);
401: BEGIN

Line 419: FND_LOOKUPS

415: CURSOR OBJ(P_OBJ IN VARCHAR2) IS
416: SELECT
417: DESCRIPTION
418: FROM
419: FND_LOOKUPS
420: WHERE LOOKUP_TYPE = 'XTR_HEDGE_OBJECTIVE_TYPES'
421: AND LOOKUP_CODE = P_OBJ;
422: L_OBJDESC VARCHAR2(240);
423: BEGIN

Line 441: FND_LOOKUPS

437: CURSOR RISK(P_CODE IN VARCHAR2) IS
438: SELECT
439: MEANING
440: FROM
441: FND_LOOKUPS
442: WHERE LOOKUP_TYPE = 'XTR_HEDGE_RISK_TYPES'
443: AND LOOKUP_CODE = P_CODE;
444: L_RISKNAME VARCHAR2(80);
445: BEGIN