APPS.IGR_VAL_EPI dependencies on IGR_I_PKG_ITEMS_V

Line 74: cp_package_item IGR_I_PKG_ITEMS_V.package_item%TYPE) IS

70: gv_other_detail VARCHAR2(255);
71: BEGIN -- check if the package_item is closed
72: DECLARE
73: CURSOR c_get_closed_ind (
74: cp_package_item IGR_I_PKG_ITEMS_V.package_item%TYPE) IS
75: SELECT actual_avail_from_date,actual_avail_to_date
76: FROM igr_i_pkg_items_v
77: WHERE package_item = p_package_item;
78: l_get_closed_ind_rec c_get_closed_ind%ROWTYPE;

Line 76: FROM igr_i_pkg_items_v

72: DECLARE
73: CURSOR c_get_closed_ind (
74: cp_package_item IGR_I_PKG_ITEMS_V.package_item%TYPE) IS
75: SELECT actual_avail_from_date,actual_avail_to_date
76: FROM igr_i_pkg_items_v
77: WHERE package_item = p_package_item;
78: l_get_closed_ind_rec c_get_closed_ind%ROWTYPE;
79: BEGIN
80: p_message_name := null;