APPS.MSC_SCN_UTILS dependencies on MSC_FORM_QUERY

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

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

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

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