APPS.GMD_OPERATIONS_PVT dependencies on GMD_ROUTINGS_B

Line 177: FROM fm_rout_dtl d, gmd_routings_b r

173:
174: CURSOR get_rt_start_end_dates(v_oprn_id NUMBER) IS
175: SELECT min(effective_start_date) effective_start_date,
176: max(NVL(effective_end_date, trunc(SYSDATE + 999999) )) effective_end_date
177: FROM fm_rout_dtl d, gmd_routings_b r
178: WHERE d.oprn_id = v_oprn_id
179: AND r.routing_id = d.routing_id
180: AND r.delete_mark = 0;
181: