27:
28: /* Cursor to fetch routing details */
29: CURSOR Get_routing_details (v_routing_id NUMBER) IS
30: SELECT r.routingstep_id, r.routingstep_no, r.oprn_id, o.oprn_no
31: FROM fm_rout_dtl r, gmd_operations_b o
32: WHERE r.routing_id = v_routing_id
33: AND r.oprn_id = o.oprn_id
34: ORDER BY r.routingstep_no;
35:
738: ORDER BY resources;
739:
740: CURSOR Get_routingstep_details(v_routingstep_id NUMBER) IS
741: SELECT r.routingstep_id,r.oprn_id
742: FROM fm_rout_dtl r
743: WHERE r.routingstep_id = v_routingstep_id;
744:
745:
746: l_parent_entity_name GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255;