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 394: select lookup_code, meaning from fnd_lookup_values

390: l_Level varchar2(15);
391:
392:
393: CURSOR c_del_new_nodes is
394: select lookup_code, meaning from fnd_lookup_values
395: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
396:
397: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
398: SELECT meaning

Line 399: FROM fnd_lookup_values

395: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
396:
397: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
398: SELECT meaning
399: FROM fnd_lookup_values
400: WHERE lookup_type = in_lookup_type
401: AND lookup_code = in_lookup_code
402: AND LANGUAGE = userenv('LANG');
403:

Line 759: select lookup_code, meaning from fnd_lookup_values

755: l_person_id NUMBER;
756: l_check NUMBER;
757:
758: CURSOR c_del_new_nodes is
759: select lookup_code, meaning from fnd_lookup_values
760: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
761:
762: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
763: SELECT meaning

Line 764: FROM fnd_lookup_values

760: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
761:
762: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
763: SELECT meaning
764: FROM fnd_lookup_values
765: WHERE lookup_type = in_lookup_type
766: AND lookup_code = in_lookup_code
767: AND LANGUAGE = userenv('LANG');
768:

Line 1154: select lookup_code, meaning from fnd_lookup_values

1150: l_person_id NUMBER;
1151:
1152:
1153: CURSOR c_del_new_nodes is
1154: select lookup_code, meaning from fnd_lookup_values
1155: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1156:
1157: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1158: SELECT meaning

Line 1159: FROM fnd_lookup_values

1155: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1156:
1157: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1158: SELECT meaning
1159: FROM fnd_lookup_values
1160: WHERE lookup_type = in_lookup_type
1161: AND lookup_code = in_lookup_code
1162: AND LANGUAGE = userenv('LANG');
1163: