APPS.MSC_BI2EBS_PKG dependencies on MSC_PHUB_CATEGORIES_MV

Line 102: select sr_category_id from msc_phub_categories_mv

98: where mtp.organization_code = p_org_name
99: and mtp.partner_type=3;
100:
101: cursor c_category_id(p_category_name varchar2) is
102: select sr_category_id from msc_phub_categories_mv
103: where CATEGORY_NAME = p_category_name
104: and category_set_id = fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
105:
106: cursor c_item_id(p_plan_id number,p_item_name varchar2) is