APPS.GMD_API_GRP dependencies on FM_ROUT_HDR

Line 857: FROM fm_rout_hdr

853: OR formula_status between 400 and 499));
854:
855: CURSOR Cur_get_rout_sts(entity_id NUMBER) IS
856: SELECT routing_status
857: FROM fm_rout_hdr
858: WHERE routing_id = entity_id
859: AND ((routing_status between 700 and 799
860: OR routing_status between 400 and 499));
861:

Line 1303: FROM fm_rout_hdr

1299: WHERE formula_id = V_entity_id
1300: AND formula_status >= V_entity_status;
1301: CURSOR Cur_get_def_routing_status IS
1302: SELECT routing_status
1303: FROM fm_rout_hdr
1304: WHERE routing_id = V_entity_id
1305: AND routing_status >= V_entity_status;
1306: /* do we need this-not used*/
1307: l_operation_status gmd_operations.operation_status%TYPE;

Line 1309: l_routing_status fm_rout_hdr.routing_status%TYPE;

1305: AND routing_status >= V_entity_status;
1306: /* do we need this-not used*/
1307: l_operation_status gmd_operations.operation_status%TYPE;
1308: l_formula_status fm_form_mst.formula_status%TYPE;
1309: l_routing_status fm_rout_hdr.routing_status%TYPE;
1310: BEGIN
1311: /*Check all the operations inserted are of status APFLU or APFGU*/
1312: IF (V_entity_type = 'OPERATION') THEN
1313: OPEN Cur_get_def_oprn_status;