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 6667: FROM fnd_lookup_values_vl

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

Line 6943: FROM fnd_lookup_values_vl

6939: AND cle_id =vLine_id;
6940:
6941: CURSOR c IS
6942: SELECT meaning
6943: FROM fnd_lookup_values_vl
6944: WHERE lookup_type = 'VER_COMP_OBJECT_TYPE'
6945: AND lookup_code = l_Object
6946: AND view_application_id=777;
6947: