[Home] [Help]
19: gea.actual_task_id,
20: pt.top_task_id,
21: sum(gea.bill_amount) billed_amount -- null handling not reqd.
22: from gms_event_attribute gea,
23: pa_tasks pt
24: where gea.project_id = P_AWARD_PROJECT_ID
25: and gea.event_num in ( -1,-2)
26: and gea.request_id = P_REQUEST_ID
27: and gea.event_calling_process = 'Invoice'
188: set total_billed_amount = total_billed_amount + X_Amount
189: where project_id = X_Actual_Project_Id
190: and (task_id is null
191: or task_id = X_Actual_Task_id
192: or task_id = (select top_task_id from pa_tasks where task_id = X_Actual_Task_id) -- Bug 2369179,Added
193: )
194: and installment_id = X_Installment_id;
195:
196: /* Write_off Creation */
201: set total_billed_amount = total_billed_amount - X_Amount
202: where project_id = X_Actual_Project_Id
203: and (task_id is null
204: or task_id = X_Actual_Task_id
205: or task_id = (select top_task_id from pa_tasks where task_id = X_Actual_Task_id) -- Bug 2369179,Added
206: )
207: and installment_id = X_Installment_id;
208:
209: End if;
581: and spf.project_id = X_Act_Project_Id
582: and (
583: (spf.task_id IS NULL)
584: OR (spf.task_id = X_Act_Task_Id)
585: OR (spf.task_id = (select top_task_id from pa_tasks where task_id = X_Act_Task_Id))
586: );
587:
588: X_Amount := St_Amount;
589:
680: and spf.project_id = F_actual_project_id
681: and (
682: (spf.task_id IS NULL)
683: OR (spf.task_id = F_actual_task_id)
684: OR (spf.task_id = (select t.top_task_id from pa_tasks t where t.task_id = F_actual_task_id))
685: );
686:
687: Elsif
688:
698: and spf.project_id = F_actual_project_id
699: and (
700: (spf.task_id IS NULL)
701: OR (spf.task_id = F_actual_task_id)
702: OR (spf.task_id = (select t.top_task_id from pa_tasks t where t.task_id = F_actual_task_id))
703: );
704:
705: End If;
706: