[Home] [Help]
502: select aw.award_id award_id
503: from pa_tasks t ,
504: gms_installments ins,
505: gms_summary_project_fundings su,
506: gms_budget_versions bv,
507: gms_awards_all aw --- Added for Bug#13370217
508: where bv.budget_status_code = 'B'
509: and bv.project_id = P_Project_Id
510: and bv.award_id = P_award_id