APPS.GMD_SEARCH_REPLACE_VERS dependencies on FM_ROUT_HDR

Line 51: FROM fm_rout_hdr

47: SELECT gem5_routing_id_s.NEXTVAL
48: FROM FND_DUAL;
49: CURSOR Cur_get_hdr IS
50: SELECT *
51: FROM fm_rout_hdr
52: WHERE routing_id = p_routing_id;
53: X_hdr_rec Cur_get_hdr%ROWTYPE;
54: CURSOR Cur_rout_vers IS
55: SELECT MAX(routing_vers) + 1

Line 56: FROM fm_rout_hdr

52: WHERE routing_id = p_routing_id;
53: X_hdr_rec Cur_get_hdr%ROWTYPE;
54: CURSOR Cur_rout_vers IS
55: SELECT MAX(routing_vers) + 1
56: FROM fm_rout_hdr
57: WHERE routing_no = X_hdr_rec.routing_no;
58:
59: CURSOR Cur_get_dtl IS
60: SELECT *