APPS.MSC_PERS_QUERIES dependencies on MSC_WORKLIST_GROUPBY

Line 89: FROM MSC_WORKLIST_GROUPBY

85: order by sequence;
86:
87: CURSOR c_wl_groupby(l_query IN NUMBER) IS
88: SELECT distinct ATTRIBUTE_NAME group_by
89: FROM MSC_WORKLIST_GROUPBY
90: WHERE QUERY_ID = l_query;
91:
92: cursor c_excp_types (l_query_id number) is
93: select source_type, object_type, sequence_id,NVL(priority,999), frequency

Line 736: FROM MSC_WORKLIST_GROUPBY

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
737: WHERE QUERY_ID = p_query_id;
738:
739:
740: l_save_as_query_id number;

Line 818: INSERT INTO MSC_WORKLIST_GROUPBY(

814: rec_pers_criteria.TO_FIELD_VALUE,rec_pers_criteria.OBJECT_TYPE,
815: rec_pers_criteria.SOURCE_TYPE, rec_pers_criteria.ACTIVE_FLAG) ;
816: end loop;
817:
818: INSERT INTO MSC_WORKLIST_GROUPBY(
819: QUERY_ID ,
820: ATTRIBUTE_NAME ,
821: CHAR1 ,
822: CHAR2 ,

Line 841: FROM MSC_WORKLIST_GROUPBY

837: LAST_UPDATE_DATE ,
838: LAST_UPDATED_BY ,
839: CREATION_DATE ,
840: CREATED_BY
841: FROM MSC_WORKLIST_GROUPBY
842: WHERE query_id = p_query_id;
843: return l_save_as_query_id;
844: end copy_query;
845: