APPS.IEX_UWQ_DELIN_ENUMS_PVT dependencies on FND_LOOKUP_VALUES

Line 56: select lookup_code, meaning from fnd_lookup_values

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

Line 61: FROM fnd_lookup_values

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

Line 589: select lookup_code, meaning from fnd_lookup_values

585: from jtf_rs_resource_extns
586: where resource_id = p_resource_id;
587:
588: CURSOR c_del_new_nodes is
589: select lookup_code, meaning from fnd_lookup_values
590: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
591:
592: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
593: SELECT meaning

Line 594: FROM fnd_lookup_values

590: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
591:
592: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
593: SELECT meaning
594: FROM fnd_lookup_values
595: WHERE lookup_type = in_lookup_type
596: AND lookup_code = in_lookup_code
597: AND LANGUAGE = userenv('LANG');
598:

Line 1151: select lookup_code, meaning from fnd_lookup_values

1147: from jtf_rs_resource_extns
1148: where resource_id = p_resource_id;
1149:
1150: CURSOR c_del_new_nodes is
1151: select lookup_code, meaning from fnd_lookup_values
1152: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1153:
1154: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1155: SELECT meaning

Line 1156: FROM fnd_lookup_values

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

Line 1829: select lookup_code, meaning from fnd_lookup_values

1825: from jtf_rs_resource_extns
1826: where resource_id = p_resource_id;
1827:
1828: CURSOR c_del_new_nodes is
1829: select lookup_code, meaning from fnd_lookup_values
1830: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1831:
1832: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1833: SELECT meaning

Line 1834: FROM fnd_lookup_values

1830: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1831:
1832: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1833: SELECT meaning
1834: FROM fnd_lookup_values
1835: WHERE lookup_type = in_lookup_type
1836: AND lookup_code = in_lookup_code
1837: AND LANGUAGE = userenv('LANG');
1838: