APPS.AHL_DI_DOC_REVISION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 37: FROM FND_LOOKUP_VALUES_VL

33: --Cursor to retrieve the revision type code
34: CURSOR get_revision_type_code(c_revision_type_code VARCHAR2)
35: IS
36: SELECT lookup_code
37: FROM FND_LOOKUP_VALUES_VL
38: WHERE lookup_code = c_revision_type_code
39: AND lookup_type = 'AHL_REVISION_TYPE'
40: AND sysdate between start_date_active
41: AND nvl(end_date_active,sysdate);

Line 47: FROM FND_LOOKUP_VALUES_VL

43: --Cursor to retrieve revision status code
44: CURSOR get_revision_status_code(c_revision_status_code VARCHAR2)
45: IS
46: SELECT lookup_code
47: FROM FND_LOOKUP_VALUES_VL
48: WHERE lookup_code = c_revision_status_code
49: AND lookup_type = 'AHL_REVISION_STATUS_TYPE'
50: AND sysdate between start_date_active
51: AND nvl(end_date_active,sysdate);

Line 57: FROM FND_LOOKUP_VALUES_VL

53: --Cursor to retrieve media type code
54: CURSOR get_media_type_code(c_media_type_code VARCHAR2)
55: IS
56: SELECT lookup_code
57: FROM FND_LOOKUP_VALUES_VL
58: WHERE lookup_code = c_media_type_code
59: AND lookup_type = 'AHL_MEDIA_TYPE'
60: AND sysdate between start_date_active
61: AND nvl(end_date_active,sysdate);

Line 298: FROM FND_LOOKUP_VALUES_VL

294: FETCH get_record_from_AHL into l_dummy;
295: IF get_record_from_AHL%FOUND THEN
296: --{{adharia to add a token to the message
297: SELECT MEANING into l_media_type_meaning
298: FROM FND_LOOKUP_VALUES_VL
299: WHERE LOOKUP_TYPE='AHL_MEDIA_TYPE' AND LOOKUP_CODE='E-FILE';
300:
301: FND_MESSAGE.SET_NAME('AHL','AHL_DI_MEDTYP_NOT_EFILE');
302: FND_MESSAGE.SET_TOKEN('EFILE',l_media_type_meaning);