APPS.AHL_DI_PRO_TYPE_ASO_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 36: FROM FND_LOOKUP_VALUES_VL

32: -- Cursor to retrieve the doc sub type code from fnd lookups
33: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
34: IS
35: SELECT lookup_code,meaning
36: FROM FND_LOOKUP_VALUES_VL
37: WHERE lookup_code = c_doc_sub_type_code
38: AND lookup_type = 'AHL_DOC_SUB_TYPE'
39: AND sysdate between start_date_active
40: AND nvl(end_date_active,sysdate);

Line 196: FROM FND_LOOKUP_VALUES_VL

192: -- Cursor to retrieve the doc sub type code from fnd lookups
193: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
194: IS
195: SELECT lookup_code,meaning
196: FROM FND_LOOKUP_VALUES_VL
197: WHERE lookup_code = c_doc_sub_type_code
198: AND lookup_type = 'AHL_DOC_SUB_TYPE'
199: AND sysdate between start_date_active
200: AND nvl(end_date_active,sysdate);

Line 414: FROM FND_LOOKUP_VALUES_VL

410: -- Cursor to retrieve the doc sub type code from fnd lookups
411: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
412: IS
413: SELECT lookup_code,meaning
414: FROM FND_LOOKUP_VALUES_VL
415: WHERE lookup_code = c_doc_sub_type_code
416: AND lookup_type = 'AHL_DOC_SUB_TYPE'
417: AND sysdate between start_date_active
418: AND nvl(end_date_active,sysdate);

Line 711: FROM FND_LOOKUP_VALUES_VL

707: -- Cursor to retrieve the doc sub type code from fnd lookups
708: CURSOR get_doc_sub_type_code(c_doc_sub_type_code VARCHAR2)
709: IS
710: SELECT meaning
711: FROM FND_LOOKUP_VALUES_VL
712: WHERE lookup_code = c_doc_sub_type_code
713: AND lookup_type = 'AHL_DOC_SUB_TYPE'
714: AND sysdate between start_date_active
715: AND nvl(end_date_active,sysdate);