APPS.AHL_UTIL_MC_PKG dependencies on FND_LOOKUPS

Line 24: FROM FND_LOOKUPS

20: p_lookup_code IN VARCHAR2
21: )
22: IS
23: SELECT 'x'
24: FROM FND_LOOKUPS
25: WHERE lookup_type = p_lookup_type AND
26: lookup_code = p_lookup_code AND
27: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1)) AND
28: --JKJain, Bug 12593041 29th July 2011.

Line 67: FROM fnd_lookups

63: p_lookup_meaning IN VARCHAR2
64: )
65: IS
66: SELECT lookup_code
67: FROM fnd_lookups
68: WHERE lookup_type = p_lookup_type AND
69: upper(meaning) = upper(p_lookup_meaning) AND
70: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
71:

Line 72: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;

68: WHERE lookup_type = p_lookup_type AND
69: upper(meaning) = upper(p_lookup_meaning) AND
70: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
71:
72: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
73: l_dummy_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
74: l_return_val BOOLEAN DEFAULT TRUE;
75:
76: BEGIN

Line 73: l_dummy_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;

69: upper(meaning) = upper(p_lookup_meaning) AND
70: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
71:
72: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
73: l_dummy_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
74: l_return_val BOOLEAN DEFAULT TRUE;
75:
76: BEGIN
77:

Line 124: FROM fnd_lookups

120: p_lookup_code IN VARCHAR2
121: )
122: IS
123: SELECT meaning
124: FROM fnd_lookups
125: WHERE lookup_type = p_lookup_type AND
126: lookup_code = p_lookup_code AND
127: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
128:

Line 129: l_lookup_meaning fnd_lookups.meaning%TYPE DEFAULT NULL;

125: WHERE lookup_type = p_lookup_type AND
126: lookup_code = p_lookup_code AND
127: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
128:
129: l_lookup_meaning fnd_lookups.meaning%TYPE DEFAULT NULL;
130: l_return_val BOOLEAN DEFAULT TRUE;
131:
132: BEGIN
133: