APPS.GMDRTVAL_PUB dependencies on GMD_OPERATIONS_B

Line 314: FROM gmd_operations_b

310: /* Cursor Definitions. */
311: /* =================== */
312: CURSOR Cur_get_oprn IS
313: SELECT oprn_no, oprn_vers, effective_start_date, effective_end_date
314: FROM gmd_operations_b
315: WHERE ((poprn_id IS NOT NULL AND oprn_id = poprn_id)
316: OR (poprn_id IS NULL AND (oprn_no = poprn_no
317: AND oprn_vers = poprn_vers)
318: )

Line 744: SELECT count(*) FROM gmd_operations_b

740:
741: l_oprn_count NUMBER := 0;
742:
743: CURSOR check_oprn_count IS
744: SELECT count(*) FROM gmd_operations_b
745: WHERE oprn_id IN (select oprn_id from fm_rout_dtl where routing_id = pRouting_id);
746:
747: BEGIN
748: x_return_status := 'S';