APPS.IGR_INFTYP_PKG_IT_CRM_PKG dependencies on IGR_I_ITYP_PKGS_V

Line 59: CURSOR c_package_items( l_info_type_id igr_i_ityp_pkgs_v.info_type_id%TYPE ) IS

55: l_info_type_id ams_deliv_kit_items.deliverable_kit_id%TYPE;
56: l_var NUMBER(10);
57: l_row_id VARCHAR2(25);
58:
59: CURSOR c_package_items( l_info_type_id igr_i_ityp_pkgs_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:

Line 61: FROM igr_i_ityp_pkgs_v

57: l_row_id VARCHAR2(25);
58:
59: CURSOR c_package_items( l_info_type_id igr_i_ityp_pkgs_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.*