APPS.GMD_STATUS_PUB dependencies on GMD_OPERATION_ACTIVITIES

Line 33: FROM gmd_operation_activities a

29: x_return_status OUT NOCOPY VARCHAR2)IS
30:
31: CURSOR Cur_get_activities(poprn_id NUMBER) IS
32: SELECT activity
33: FROM gmd_operation_activities a
34: WHERE NOT EXISTS (select 'X' from gmd_operation_resources r
35: where a.oprn_line_id = r.oprn_line_id)
36: AND a.oprn_id = poprn_id;
37: