DBA Data[Home] [Help]

APPS.GMD_VERSION_CONTROL dependencies on FM_ROUT_HDR

Line 188: FROM fm_rout_hdr

184: SELECT gem5_routing_id_s.NEXTVAL
185: FROM FND_DUAL;
186: CURSOR Cur_get_hdr IS
187: SELECT *
188: FROM fm_rout_hdr
189: WHERE routing_id = p_routing_id;
190: X_hdr_rec Cur_get_hdr%ROWTYPE;
191: CURSOR Cur_rout_vers IS
192: SELECT MAX(routing_vers) + 1

Line 193: FROM fm_rout_hdr

189: WHERE routing_id = p_routing_id;
190: X_hdr_rec Cur_get_hdr%ROWTYPE;
191: CURSOR Cur_rout_vers IS
192: SELECT MAX(routing_vers) + 1
193: FROM fm_rout_hdr
194: WHERE routing_no = X_hdr_rec.routing_no;
195:
196: CURSOR Cur_get_dtl IS
197: SELECT *