APPS.GMD_STATUS_PUB dependencies on GMD_OPERATION_RESOURCES
Line 34: WHERE NOT EXISTS (select 'X' from gmd_operation_resources r
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:
38: x_count NUMBER;