DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_CATEGORY_SETS

Line 4751: from msc_category_sets

4747:
4748:
4749: cursor c_default_cat is
4750: select to_char(category_set_id)
4751: from msc_category_sets
4752: where default_flag = 1;
4753:
4754: begin
4755: if p_pref_id is not null then

Line 5599: from msc_category_sets

5595: FUNCTION category_set_name(p_cat_set_id NUMBER) return varchar2 is
5596:
5597: cursor c_cat_set_name is
5598: select category_set_name
5599: from msc_category_sets
5600: where category_set_id = p_cat_set_id;
5601:
5602: l_cat_set_name varchar2(30);
5603: begin