DBA Data[Home] [Help]

APPS.MST_PQ_WORKS dependencies on MST_LOAD_SELECTION_CRITERIA

Line 875: DELETE MST_LOAD_SELECTION_CRITERIA

871: IF NOT sql%FOUND THEN
872: RETURN;
873: END IF;
874: IF P_QUERY_TYPE = 1 THEN
875: DELETE MST_LOAD_SELECTION_CRITERIA
876: WHERE query_id = p_query_id;
877: ELSIF P_QUERY_TYPE = 2 THEN
878: DELETE MST_CM_SELECTION_CRITERIA
879: WHERE query_id = p_query_id;

Line 932: from mst_load_selection_criteria

928: CUBE_TYPE , CUBE_FROM , CUBE_TO ,
929: UTILIZATION_TYPE , UTILIZATION_FROM, UTILIZATION_TO,
930: DEPARTURE_TIME_TYPE, DEPARTURE_TIME_FROM,
931: DEPARTURE_TIME_TO , DEPARTURE_TIME_UNIT
932: from mst_load_selection_criteria
933: where query_id = p_query_id;
934:
935: l_rec_loads cur_loads%ROWTYPE;
936: