APPS.MSC_PERS_QUERIES dependencies on MSC_WORKLIST_GROUPBY

Line 99: FROM MSC_WORKLIST_GROUPBY

95: order by sequence;
96:
97: CURSOR c_wl_groupby(l_query IN NUMBER) IS
98: SELECT distinct ATTRIBUTE_NAME group_by
99: FROM MSC_WORKLIST_GROUPBY
100: WHERE QUERY_ID = l_query;
101:
102: cursor c_excp_types (l_query_id number) is
103: select source_type, object_type, sequence_id,NVL(priority,999), frequency

Line 804: FROM MSC_WORKLIST_GROUPBY

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
805: WHERE QUERY_ID = p_query_id;
806:
807:
808: l_save_as_query_id number;

Line 905: INSERT INTO MSC_WORKLIST_GROUPBY(

901: rec_among_criteria.LAST_UPDATED_BY,
902: rec_among_criteria.LAST_UPDATE_LOGIN);
903: END LOOP;
904:
905: INSERT INTO MSC_WORKLIST_GROUPBY(
906: QUERY_ID ,
907: ATTRIBUTE_NAME ,
908: CHAR1 ,
909: CHAR2 ,

Line 928: FROM MSC_WORKLIST_GROUPBY

924: LAST_UPDATE_DATE ,
925: LAST_UPDATED_BY ,
926: CREATION_DATE ,
927: CREATED_BY
928: FROM MSC_WORKLIST_GROUPBY
929: WHERE query_id = p_query_id;
930: return l_save_as_query_id;
931: end copy_query;
932:

Line 1098: FROM MSC_WORKLIST_GROUPBY

1094: l_group_by varchar2(30);
1095:
1096: CURSOR c_wl_groupby(l_query IN NUMBER) IS
1097: SELECT distinct ATTRIBUTE_NAME group_by
1098: FROM MSC_WORKLIST_GROUPBY
1099: WHERE QUERY_ID = l_query;
1100: begin
1101: OPEN c_wl_groupby (p_query_id) ;
1102: LOOP