DBA Data[Home] [Help]

APPS.MSC_PERS_QUERIES dependencies on MSC_FORM_QUERY

Line 748: from msc_form_query

744: insert into msc_query (query_id, number1,
745: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
746: select p_query_id, number1 ,
747: sysdate, -1, sysdate, -1
748: from msc_form_query
749: where query_id = p_query_id;
750:
751: commit;
752: end populate_cp_temp_table;

Line 800: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s

796: from msc_among_values
797: where folder_id = p_query_id;
798:
799: cursor c_query is select msc_personal_queries_s.nextval from dual;
800: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s
801:
802: CURSOR c_group_by(p_query_id IN NUMBER) IS
803: SELECT distinct ATTRIBUTE_NAME group_by
804: FROM MSC_WORKLIST_GROUPBY