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));
28:
61: p_lookup_meaning IN VARCHAR2
62: )
63: IS
64: SELECT lookup_code
65: FROM fnd_lookups
66: WHERE lookup_type = p_lookup_type AND
67: upper(meaning) = upper(p_lookup_meaning) AND
68: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
69:
66: WHERE lookup_type = p_lookup_type AND
67: upper(meaning) = upper(p_lookup_meaning) AND
68: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
69:
70: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
71: l_dummy_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
72: l_return_val BOOLEAN DEFAULT TRUE;
73:
74: BEGIN
67: upper(meaning) = upper(p_lookup_meaning) AND
68: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
69:
70: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
71: l_dummy_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
72: l_return_val BOOLEAN DEFAULT TRUE;
73:
74: BEGIN
75:
118: p_lookup_code IN VARCHAR2
119: )
120: IS
121: SELECT meaning
122: FROM fnd_lookups
123: WHERE lookup_type = p_lookup_type AND
124: lookup_code = p_lookup_code AND
125: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
126:
123: WHERE lookup_type = p_lookup_type AND
124: lookup_code = p_lookup_code AND
125: G_TRUNC_DATE between TRUNC(NVL(start_date_active, SYSDATE)) AND TRUNC(NVL(end_date_active, SYSDATE+1));
126:
127: l_lookup_meaning fnd_lookups.meaning%TYPE DEFAULT NULL;
128: l_return_val BOOLEAN DEFAULT TRUE;
129:
130: BEGIN
131: