APPS.MSC_SCN_UTILS dependencies on MSC_FORM_QUERY

Line 2369: select count(*) into l_count from msc_form_query where query_id = p_activity_type;

2365: insert_seed_data;
2366: RETURN;
2367: END IF;
2368:
2369: select count(*) into l_count from msc_form_query where query_id = p_activity_type;
2370:
2371: if nvl(l_count,0) >0 then
2372: return;
2373: end if;

Line 2381: l_insert := 'insert into msc_form_query (query_id,

2377: fetch c_activity_params into l_param_name,l_sql;
2378: exit when c_activity_params%NOTFOUND;
2379:
2380: l_substr := substr(l_sql,instr(upper(l_sql),'SELECT ')+7);
2381: l_insert := 'insert into msc_form_query (query_id,
2382: char1,
2383: last_update_date,
2384: last_updated_by,
2385: last_update_login,