1076: AND pro_project_id IS NOT NULL
1077: AND project_task_number IS NOT NULL
1078: AND project_award_number IS NOT NULL
1079: AND NOT EXISTS (SELECT 1
1080: FROM GMS_AWARDS_BASIC_V award,
1081: PA_TASKS_EXPEND_V task
1082: WHERE award.project_id = pro_project_id
1083: AND task.task_number = project_task_number
1084: AND award.task_id = task.task_id