APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 37: FROM FND_LOOKUP_VALUES_VL

33: -- Cursor to retrieve the status code from fnd lookups table
34: CURSOR get_status_code(c_status_code VARCHAR2)
35: IS
36: SELECT lookup_code
37: FROM FND_LOOKUP_VALUES_VL
38: WHERE lookup_code = c_status_code
39: AND lookup_type = 'AHL_SUBSCRIBE_STATUS_TYPE'
40: AND sysdate between start_date_active
41: AND nvl(end_date_active,sysdate);

Line 46: FROM FND_LOOKUP_VALUES_VL

42: -- Cursor to retrieve the frequency from fnd lookups
43: CURSOR get_frequency_code(c_frequency_code VARCHAR2)
44: IS
45: SELECT lookup_code
46: FROM FND_LOOKUP_VALUES_VL
47: WHERE lookup_code = c_frequency_code
48: AND lookup_type = 'AHL_FREQUENCY_TYPE'
49: AND sysdate between start_date_active
50: AND nvl(end_date_active,sysdate);

Line 55: FROM FND_LOOKUP_VALUES_VL

51: -- Cursor to retrieve the sub type code from fnd lookups table
52: CURSOR get_sub_type_code(c_subscription_type_code VARCHAR2)
53: IS
54: SELECT lookup_code
55: FROM FND_LOOKUP_VALUES_VL
56: WHERE lookup_code = c_subscription_type_code
57: AND lookup_type = 'AHL_SUBSCRIPTION_TYPE'
58: AND sysdate between start_date_active
59: AND nvl(end_date_active,sysdate);

Line 64: FROM FND_LOOKUP_VALUES_VL

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