APPS.GMDRTVAL_PUB dependencies on FM_ROUT_HDR

Line 90: FROM fm_rout_hdr

86: CURSOR Cur_check_dup IS
87: SELECT 1
88: FROM SYS.DUAL
89: WHERE EXISTS (SELECT 1
90: FROM fm_rout_hdr
91: WHERE routing_no = prouting_no
92: AND routing_vers = prouting_vers);
93: /* Local variables. */
94: /* ================ */

Line 244: from fm_rout_hdr

240: xRouting_id IN OUT NOCOPY NUMBER,
241: xReturn_status OUT NOCOPY VARCHAR2) IS
242: CURSOR Routing_No_Cur IS
243: select routing_id
244: from fm_rout_hdr
245: where routing_no = pRouting_no AND
246: routing_vers = pRouting_vers;
247:
248: Cursor Routing_id_cur IS

Line 250: from fm_rout_hdr

246: routing_vers = pRouting_vers;
247:
248: Cursor Routing_id_cur IS
249: select routing_id
250: from fm_rout_hdr
251: where routing_id = xRouting_id;
252:
253: l_return_val NUMBER;
254: