APPS.ASO_SUP_TEMPLATE_DATA_PVT dependencies on FND_LOOKUP_VALUES

Line 39: FROM fnd_lookup_values

35: and nvl(end_date_active,sysdate);
36:
37: /*
38: SELECT lookup_code
39: FROM fnd_lookup_values
40: WHERE lookup_type = 'ASO_SUP_TEMPLATE_CONTEXT'
41: AND lookup_code = p_templ_context
42: AND view_application_id = 697
43: AND LANGUAGE = userenv('LANG')

Line 49: FROM fnd_lookup_values

45: */
46:
47: CURSOR c_template_level (p_lookup_type VARCHAR2,p_templ_level VARCHAR2) IS
48: SELECT 'X'
49: FROM fnd_lookup_values
50: WHERE lookup_type = p_lookup_type
51: AND lookup_code = p_templ_level
52: AND view_application_id = 697
53: AND LANGUAGE = userenv('LANG')