APPS.MSC_PERS_QUERIES dependencies on MSC_SELECTION_CRITERIA

Line 79: from msc_selection_criteria_v

75:
76: cursor c_groupby (l_query_id in number,
77: l_source_type in number, l_object_type in number) is
78: select group_by, sequence
79: from msc_selection_criteria_v
80: where folder_id = l_query_id
81: and nvl(source_type, -1) = nvl(l_source_type, -1)
82: and nvl(object_type, -1) = nvl(l_object_type, -1)
83: and nvl(count_by, 2) = 1

Line 728: from msc_selection_criteria

724: AND_OR, COUNT_BY, SEARCH_QUERY_ID,
725: SEARCH_QUERY_NAME, DEFAULT_FLAG,
726: PUBLIC_FLAG, FROM_FIELD_VALUE, TO_FIELD_VALUE,
727: OBJECT_TYPE, SOURCE_TYPE, ACTIVE_FLAG
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

Line 792: INSERT INTO msc_selection_criteria

788: end if;
789:
790: for rec_pers_criteria in c_pers_criteria(p_query_id)
791: loop
792: INSERT INTO msc_selection_criteria
793: (SEQUENCE, FOLDER_ID, OBJECT_SEQUENCE_ID, FIELD_NAME, FIELD_TYPE,
794: HIDDEN_FROM_FIELD, CONDITION,
795: FROM_FIELD, TO_FIELD, FOLDER_OBJECT,
796: TREE_NODE, CREATION_DATE, CREATED_BY,

Line 892: delete from msc_selection_criteria

888:
889: delete from msc_pq_types
890: where query_id = p_query_id;
891:
892: delete from msc_selection_criteria
893: where folder_id = p_query_id;
894:
895: delete from msc_among_values
896: where folder_id = p_query_id;