APPS.IGR_VAL_EIT dependencies on IGR_I_INFO_TYPES_V

Line 14: igr_i_info_types_v.information_type%TYPE) IS

10: DECLARE
11: v_closed_ind CHAR;
12: CURSOR c_get_closed_ind (
13: cp_enquiry_information_type
14: igr_i_info_types_v.information_type%TYPE) IS
15: SELECT 'X'
16: FROM igr_i_info_types_v
17: WHERE information_type = p_enquiry_information_type
18: AND sysdate > ACTUAL_AVAIL_TO_DATE;

Line 16: FROM igr_i_info_types_v

12: CURSOR c_get_closed_ind (
13: cp_enquiry_information_type
14: igr_i_info_types_v.information_type%TYPE) IS
15: SELECT 'X'
16: FROM igr_i_info_types_v
17: WHERE information_type = p_enquiry_information_type
18: AND sysdate > ACTUAL_AVAIL_TO_DATE;
19: BEGIN
20: p_message_name := null;