APPS.MSC_PERS_QUERIES dependencies on MSC_AMONG_VALUES

Line 796: from msc_among_values

792: select SEQUENCE,FIELD_NAME, OR_VALUES,
793: HIDDEN_VALUES,OBJECT_SEQUENCE,ORDER_BY_SEQUENCE,
794: CREATION_DATE, CREATED_BY,
795: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
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

Line 887: INSERT INTO msc_among_values

883: rec_pers_criteria.SOURCE_TYPE, rec_pers_criteria.ACTIVE_FLAG) ;
884: end loop;
885:
886: for rec_among_criteria in c_among_criteria(p_query_id) loop
887: INSERT INTO msc_among_values
888: (FOLDER_ID,SEQUENCE,FIELD_NAME, OR_VALUES,
889: HIDDEN_VALUES,OBJECT_SEQUENCE,ORDER_BY_SEQUENCE,
890: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
891: LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 982: delete from msc_among_values

978:
979: delete from msc_selection_criteria
980: where folder_id = p_query_id;
981:
982: delete from msc_among_values
983: where folder_id = p_query_id;
984:
985: delete from msc_pq_results
986: where query_id = p_query_id;