DBA Data[Home] [Help]

APPS.MST_PQ_WORKS dependencies on MST_CM_SELECTION_CRITERIA

Line 878: DELETE MST_CM_SELECTION_CRITERIA

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;
880: ELSIF P_QUERY_TYPE = 3 THEN
881: DELETE MST_ORDER_SELECTION_CRITERIA
882: WHERE query_id = p_query_id;

Line 2370: from mst_cm_selection_criteria

2366: CARRIERS , COST_TYPE ,
2367: COST_FROM , COST_TO ,
2368: DEPARTURE_TIME_TYPE, DEPARTURE_TIME_FROM,
2369: DEPARTURE_TIME_TO , DEPARTURE_TIME_UNIT
2370: from mst_cm_selection_criteria
2371: where query_id = p_query_id;
2372:
2373: l_rec_loads cur_cms%ROWTYPE;
2374: