APPS.AHL_DI_DOC_REVISION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 42: FROM FND_LOOKUP_VALUES_VL

38: --Cursor to retrieve the revision type code
39: CURSOR get_revision_type_code(c_revision_type_code VARCHAR2)
40: IS
41: SELECT lookup_code
42: FROM FND_LOOKUP_VALUES_VL
43: WHERE lookup_code = c_revision_type_code
44: AND lookup_type = 'AHL_REVISION_TYPE'
45: AND sysdate between start_date_active
46: AND nvl(end_date_active,sysdate);

Line 52: FROM FND_LOOKUP_VALUES_VL

48: --Cursor to retrieve revision status code
49: CURSOR get_revision_status_code(c_revision_status_code VARCHAR2)
50: IS
51: SELECT lookup_code
52: FROM FND_LOOKUP_VALUES_VL
53: WHERE lookup_code = c_revision_status_code
54: AND lookup_type = 'AHL_REVISION_STATUS_TYPE'
55: AND sysdate between start_date_active
56: AND nvl(end_date_active,sysdate);

Line 62: FROM FND_LOOKUP_VALUES_VL

58: --Cursor to retrieve media type code
59: CURSOR get_media_type_code(c_media_type_code VARCHAR2)
60: IS
61: SELECT lookup_code
62: FROM FND_LOOKUP_VALUES_VL
63: WHERE lookup_code = c_media_type_code
64: AND lookup_type = 'AHL_MEDIA_TYPE'
65: AND sysdate between start_date_active
66: AND nvl(end_date_active,sysdate);

Line 336: FROM FND_LOOKUP_VALUES_VL

332: FETCH get_record_from_AHL into l_dummy;
333: IF get_record_from_AHL%FOUND THEN
334: --{{adharia to add a token to the message
335: SELECT MEANING into l_media_type_meaning
336: FROM FND_LOOKUP_VALUES_VL
337: WHERE LOOKUP_TYPE='AHL_MEDIA_TYPE' AND LOOKUP_CODE='E-FILE';
338:
339: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_NOT_EFILE');
340: FND_MESSAGE.SET_TOKEN('EFILE',l_media_type_meaning);