APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on FND_LOOKUP_VALUES

Line 55: select lookup_code, meaning from fnd_lookup_values

51: from jtf_rs_resource_extns
52: where resource_id = p_resource_id;
53:
54: CURSOR c_del_new_nodes is
55: select lookup_code, meaning from fnd_lookup_values
56: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
57:
58: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
59: SELECT meaning

Line 60: FROM fnd_lookup_values

56: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
57:
58: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
59: SELECT meaning
60: FROM fnd_lookup_values
61: WHERE lookup_type = in_lookup_type
62: AND lookup_code = in_lookup_code
63: AND LANGUAGE = userenv('LANG');
64:

Line 374: select lookup_code, meaning from fnd_lookup_values

370: l_Level varchar2(15);
371:
372:
373: CURSOR c_del_new_nodes is
374: select lookup_code, meaning from fnd_lookup_values
375: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
376:
377: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
378: SELECT meaning

Line 379: FROM fnd_lookup_values

375: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
376:
377: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
378: SELECT meaning
379: FROM fnd_lookup_values
380: WHERE lookup_type = in_lookup_type
381: AND lookup_code = in_lookup_code
382: AND LANGUAGE = userenv('LANG');
383:

Line 694: select lookup_code, meaning from fnd_lookup_values

690: l_person_id NUMBER;
691: l_check NUMBER;
692:
693: CURSOR c_del_new_nodes is
694: select lookup_code, meaning from fnd_lookup_values
695: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
696:
697: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
698: SELECT meaning

Line 699: FROM fnd_lookup_values

695: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
696:
697: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
698: SELECT meaning
699: FROM fnd_lookup_values
700: WHERE lookup_type = in_lookup_type
701: AND lookup_code = in_lookup_code
702: AND LANGUAGE = userenv('LANG');
703:

Line 1044: select lookup_code, meaning from fnd_lookup_values

1040: l_person_id NUMBER;
1041:
1042:
1043: CURSOR c_del_new_nodes is
1044: select lookup_code, meaning from fnd_lookup_values
1045: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1046:
1047: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1048: SELECT meaning

Line 1049: FROM fnd_lookup_values

1045: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1046:
1047: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1048: SELECT meaning
1049: FROM fnd_lookup_values
1050: WHERE lookup_type = in_lookup_type
1051: AND lookup_code = in_lookup_code
1052: AND LANGUAGE = userenv('LANG');
1053: