APPS.OKE_VERSION_COMPARISON_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 399: FROM fnd_lookup_values_vl

395: r_header_2 r_header;
396:
397: CURSOR c IS
398: SELECT meaning
399: FROM fnd_lookup_values_vl
400: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
401: AND lookup_code = l_Object
402: AND view_application_id=777;
403:

Line 1525: FROM fnd_lookup_values_vl

1521: ORDER BY LINE_NUMBER;
1522:
1523: CURSOR c IS
1524: SELECT meaning
1525: FROM fnd_lookup_values_vl
1526: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
1527: AND lookup_code = l_Object
1528: AND view_application_id=777;
1529:

Line 3121: FROM fnd_lookup_values_vl

3117: ORDER BY LINE_NUMBER;
3118:
3119: CURSOR c IS
3120: SELECT meaning
3121: FROM fnd_lookup_values_vl
3122: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
3123: AND lookup_code = l_Object
3124: AND view_application_id=777;
3125:

Line 4577: FROM fnd_lookup_values_vl

4573: and major_version=vVersion_2;
4574:
4575: CURSOR c IS
4576: SELECT meaning
4577: FROM fnd_lookup_values_vl
4578: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
4579: AND lookup_code = l_Object
4580: AND view_application_id=777;
4581:

Line 4757: FROM fnd_lookup_values_vl

4753: and major_version=vVersion_2;
4754:
4755: CURSOR c IS
4756: SELECT meaning
4757: FROM fnd_lookup_values_vl
4758: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
4759: AND lookup_code = l_Object
4760: AND view_application_id=777;
4761:

Line 4933: FROM fnd_lookup_values_vl

4929: AND dnz_chr_id=vHeader_id;
4930:
4931: CURSOR c IS
4932: SELECT meaning
4933: FROM fnd_lookup_values_vl
4934: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
4935: AND lookup_code = l_Object
4936: AND view_application_id=777;
4937:

Line 5134: FROM fnd_lookup_values_vl

5130: AND cle_id = vLine_id;
5131:
5132: CURSOR c IS
5133: SELECT meaning
5134: FROM fnd_lookup_values_vl
5135: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
5136: AND lookup_code = l_Object
5137: AND view_application_id=777;
5138:

Line 5391: FROM fnd_lookup_values_vl

5387:
5388:
5389: CURSOR c IS
5390: SELECT meaning
5391: FROM fnd_lookup_values_vl
5392: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
5393: AND lookup_code = l_Object
5394: AND view_application_id=777;
5395:

Line 6664: FROM fnd_lookup_values_vl

6660: AND cle_id is null;
6661:
6662: CURSOR c IS
6663: SELECT meaning
6664: FROM fnd_lookup_values_vl
6665: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
6666: AND lookup_code = l_Object
6667: AND view_application_id=777;
6668:

Line 6935: FROM fnd_lookup_values_vl

6931: AND cle_id =vLine_id;
6932:
6933: CURSOR c IS
6934: SELECT meaning
6935: FROM fnd_lookup_values_vl
6936: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
6937: AND lookup_code = l_Object
6938: AND view_application_id=777;
6939: