APPS.JTF_DSPMGRVALIDATION_GRP dependencies on FND_LOOKUP_VALUES_VL

Line 266: select count(*) from FND_LOOKUP_VALUES_VL WHERE

262: FUNCTION check_valid_context_type(p_context_type in VARCHAR2)
263: RETURN boolean
264: IS
265: CURSOR valid_context_cur (p_context_type IN VARCHAR2) IS
266: select count(*) from FND_LOOKUP_VALUES_VL WHERE
267: lookup_type = 'JTF_AMV_DELV_TYPE_CODE' and
268: lookup_code = p_context_type and
269: enabled_flag = 'Y';
270:

Line 318: select lookup_code from FND_LOOKUP_VALUES_VL WHERE

314: IS
315:
316: CURSOR valid_object_cur (p_object_type IN VARCHAR2) IS
317: select 1 from dual where exists (
318: select lookup_code from FND_LOOKUP_VALUES_VL WHERE
319: lookup_type = 'IBE_RELATIONSHIP_RULE_OBJ_TYPE' and
320: lookup_code = p_object_type and
321: lookup_code <> 'N' and
322: enabled_flag = 'Y');