APPS.GMS_SWEEPER dependencies on PA_TASKS

Line 475: FROM pa_tasks

471: ELSE
472:
473: SELECT start_date,completion_date
474: INTO x_task_start_date,x_task_end_date
475: FROM pa_tasks
476: WHERE task_id = x_bud_task_id;
477:
478: x_start_date := GREATEST(NVL(project_start_date,x_award_start_date),x_award_start_date,NVL(x_task_start_date,x_award_start_date));
479: x_end_date := LEAST(NVL(project_end_date,x_award_end_date),x_award_end_date,NVL(x_task_end_date,x_award_end_date));