APPS.MSC_BI2EBS_PKG dependencies on MSC_PHUB_CATEGORIES_MV

Line 111: select sr_category_id from msc_phub_categories_mv

107: where mtp.organization_code = p_org_name
108: and mtp.partner_type=3;
109:
110: cursor c_category_id(p_sr_instance_id number, p_category_name varchar2) is
111: select sr_category_id from msc_phub_categories_mv
112: where CATEGORY_NAME = p_category_name
113: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1')
114: and sr_instance_id = nvl(p_sr_instance_id, sr_instance_id);
115: