APPS.GMD_API_GRP dependencies on FM_ROUT_HDR

Line 860: FROM fm_rout_hdr

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

Line 1309: FROM fm_rout_hdr

1305: WHERE formula_id = V_entity_id
1306: AND formula_status >= V_entity_status;
1307: CURSOR Cur_get_def_routing_status IS
1308: SELECT routing_status
1309: FROM fm_rout_hdr
1310: WHERE routing_id = V_entity_id
1311: AND routing_status >= V_entity_status;
1312: /* do we need this-not used*/
1313: l_operation_status gmd_operations.operation_status%TYPE;

Line 1315: l_routing_status fm_rout_hdr.routing_status%TYPE;

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