DBA Data[Home] [Help]

APPS.XTR_XTRHOAPR_XMLP_PKG dependencies on FND_LOOKUPS

Line 14: FND_LOOKUPS

10: CURSOR GET_SOURCE_NAME(P_SOURCE IN VARCHAR2) IS
11: SELECT
12: MEANING
13: FROM
14: FND_LOOKUPS
15: WHERE LOOKUP_TYPE = 'XTR_HEDGE_SOURCES'
16: AND LOOKUP_CODE = P_SOURCE;
17: CURSOR GET_MISC(P_MISC IN VARCHAR2) IS
18: SELECT

Line 21: FND_LOOKUPS

17: CURSOR GET_MISC(P_MISC IN VARCHAR2) IS
18: SELECT
19: MEANING
20: FROM
21: FND_LOOKUPS
22: WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
23: AND LOOKUP_CODE = P_MISC;
24: CURSOR GET_YES_NO(P_YES_NO IN VARCHAR2) IS
25: SELECT

Line 28: FND_LOOKUPS

24: CURSOR GET_YES_NO(P_YES_NO IN VARCHAR2) IS
25: SELECT
26: MEANING
27: FROM
28: FND_LOOKUPS
29: WHERE LOOKUP_TYPE = 'YES_NO'
30: AND LOOKUP_CODE = P_YES_NO;
31: CURSOR GET_COMPANY_NAME(P_COMPANY_CODE IN VARCHAR2) IS
32: SELECT

Line 41: FND_LOOKUPS

37: CURSOR GET_FACTOR(P_FACTOR IN VARCHAR2) IS
38: SELECT
39: MEANING
40: FROM
41: FND_LOOKUPS
42: WHERE LOOKUP_TYPE = 'XTR_NUM_FACTOR'
43: AND LOOKUP_CODE = P_FACTOR;
44: CURSOR GET_REPORT_NAME(P_CONC_REQUEST_ID IN VARCHAR2) IS
45: SELECT