APPS.IGR_INFTYP_PKG_IT_CRM_PKG dependencies on IGR_I_INFO_TYPES_V

Line 64: CURSOR c_info_details (l_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS

60: SELECT 1
61: FROM igr_i_ityp_pkgs_v
62: WHERE info_type_id = l_info_type_id;
63:
64: CURSOR c_info_details (l_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS
65: SELECT a.*
66: FROM ams_p_deliverables_v a
67: WHERE a.deliverable_id = l_info_type_id;
68:

Line 69: CURSOR c_rowid (l_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS

65: SELECT a.*
66: FROM ams_p_deliverables_v a
67: WHERE a.deliverable_id = l_info_type_id;
68:
69: CURSOR c_rowid (l_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS
70: SELECT rowid
71: FROM igr_i_pkg_item
72: WHERE package_item_id = l_info_type_id;
73: