APPS.IEU_ESCALATIONS_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 23: fnd_lookup_values_vl lkups

19: CURSOR c_ESC_nodes_1 IS
20: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */
21: distinct lkups.meaning name, tasks_b.escalation_level
22: from jtf_tasks_b tasks_b ,
23: fnd_lookup_values_vl lkups
24: WHERE tasks_b.open_flag = 'Y'
25: and nvl(tasks_b.deleted_flag,'N') = 'N'
26: and tasks_b.entity ='ESCALATION'
27: and lkups.lookup_type = 'JTF_TASK_ESC_LEVEL'

Line 35: from fnd_lookup_values_vl lkups

31: ORDER BY 1;
32:
33: CURSOR c_ESC_nodes_2 IS
34: SELECT lkups.meaning name, lkups.lookup_code escalation_level
35: from fnd_lookup_values_vl lkups
36: WHERE lkups.lookup_type = 'JTF_TASK_ESC_LEVEL'
37: ORDER BY 1;
38:
39: BEGIN

Line 51: from fnd_lookup_values_vl

47: SAVEPOINT start_enumeration;
48:
49:
50: Select meaning into l_node_label
51: from fnd_lookup_values_vl
52: where lookup_type = 'IEU_NODE_LABELS'
53: and view_application_id = 696
54: and lookup_code = 'IEU_UWQ_ESC_LBL';
55: