184: FND_MSG_PUB.ADD;
185:
186: End;
187:
188: ELSIF p_lookup_table = 'FND_LOOKUP_VALUES' THEN
189: Begin
190: SELECT lookup_code
191: INTO l_dummy_lookup
192: FROM fnd_lookup_values
188: ELSIF p_lookup_table = 'FND_LOOKUP_VALUES' THEN
189: Begin
190: SELECT lookup_code
191: INTO l_dummy_lookup
192: FROM fnd_lookup_values
193: WHERE lookup_type = p_lookup_type
194: AND lookup_code = p_column_value
195: AND enabled_flag = 'Y'
196: AND nvl(end_date_active,sysdate+1) > sysdate;