DBA Data[Home] [Help]

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

475: from jtf_rs_resource_extns
476: where resource_id = p_resource_id;
477:
478: CURSOR c_del_new_nodes is
479: select lookup_code, meaning from fnd_lookup_values
480: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
481:
482: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
483: SELECT meaning

Line 484: FROM fnd_lookup_values

480: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
481:
482: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
483: SELECT meaning
484: FROM fnd_lookup_values
485: WHERE lookup_type = in_lookup_type
486: AND lookup_code = in_lookup_code
487: AND LANGUAGE = userenv('LANG');
488:

Line 1007: select lookup_code, meaning from fnd_lookup_values

1003: from jtf_rs_resource_extns
1004: where resource_id = p_resource_id;
1005:
1006: CURSOR c_del_new_nodes is
1007: select lookup_code, meaning from fnd_lookup_values
1008: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1009:
1010: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1011: SELECT meaning

Line 1012: FROM fnd_lookup_values

1008: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1009:
1010: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1011: SELECT meaning
1012: FROM fnd_lookup_values
1013: WHERE lookup_type = in_lookup_type
1014: AND lookup_code = in_lookup_code
1015: AND LANGUAGE = userenv('LANG');
1016:

Line 1650: select lookup_code, meaning from fnd_lookup_values

1646: from jtf_rs_resource_extns
1647: where resource_id = p_resource_id;
1648:
1649: CURSOR c_del_new_nodes is
1650: select lookup_code, meaning from fnd_lookup_values
1651: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1652:
1653: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1654: SELECT meaning

Line 1655: FROM fnd_lookup_values

1651: where lookup_type = 'IEX_UWQ_NODE_STATUS' and LANGUAGE = userenv('LANG');
1652:
1653: CURSOR c_node_label(in_lookup_type VARCHAR2,in_lookup_code VARCHAR2) IS
1654: SELECT meaning
1655: FROM fnd_lookup_values
1656: WHERE lookup_type = in_lookup_type
1657: AND lookup_code = in_lookup_code
1658: AND LANGUAGE = userenv('LANG');
1659: