DBA Data[Home] [Help]

APPS.MSC_PERS_QUERIES dependencies on MSC_FORM_QUERY

Line 688: from msc_form_query

684: insert into msc_query (query_id, number1,
685: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
686: select p_query_id, number1 ,
687: sysdate, -1, sysdate, -1
688: from msc_form_query
689: where query_id = p_query_id;
690:
691: commit;
692: end populate_cp_temp_table;

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

728: from msc_selection_criteria
729: where folder_id = p_query;
730:
731: cursor c_query is select msc_personal_queries_s.nextval from dual;
732: --5746041 bugfix, changed from msc_form_query_s to msc_personal_queries_s
733:
734: CURSOR c_group_by(p_query_id IN NUMBER) IS
735: SELECT distinct ATTRIBUTE_NAME group_by
736: FROM MSC_WORKLIST_GROUPBY