APPS.GMD_ROUTINGS_PVT dependencies on FM_ROUT_DTL

Line 213: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;

209: ) IS
210:
211: /* Local variable section */
212: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING';
213: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
214: l_steprow NUMBER := 0;
215: l_db_date DATE;
216:
217: l_oprn_start_date DATE;

Line 245: From fm_rout_dtl

241: Where Routing_id = vRouting_id;
242:
243: CURSOR get_nonmanual_step_release(vRouting_id gmd_routings.routing_id%TYPE) IS
244: Select routingstep_id
245: From fm_rout_dtl
246: Where Routing_id = vRouting_id
247: And steprelease_type <> 1;
248:
249: CURSOR Get_db_last_update_date(vRouting_id gmd_routings.routing_id%TYPE) IS

Line 257: FROM gmd_operations_b o, fm_rout_dtl d

253:
254: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
255: SELECT max(effective_start_date) effective_start_date
256: , min(effective_end_date) effective_end_date
257: FROM gmd_operations_b o, fm_rout_dtl d
258: WHERE o.oprn_id = d.oprn_id
259: AND d.routing_id = vRouting_id
260: AND o.delete_mark = 0;
261:

Line 632: FROM gmd_operations_b o, fm_rout_dtl d

628:
629: CURSOR Get_oprn_start_end_dates(vRouting_id NUMBER) IS
630: SELECT max(effective_start_date) effective_start_date
631: , min(effective_end_date) effective_end_date
632: FROM gmd_operations_b o, fm_rout_dtl d
633: WHERE o.oprn_id = d.oprn_id
634: AND d.routing_id = vRouting_id
635: AND o.delete_mark = 0;
636: BEGIN