DBA Data[Home] [Help]

APPS.GMS_TRANSACTIONS_PUB dependencies on GMS_AWARDS_ALL

Line 483: from GMS_AWARDS_all --- Added for Bug#13370217

479: nvl(Preaward_Date,START_DATE_ACTIVE),
480: End_Date_Active,
481: Close_Date,
482: Status
483: from GMS_AWARDS_all --- Added for Bug#13370217
484: where award_id = P_award_id;
485: --where award_id = to_number( P_award_id);
486:
487: X_Allowable_Schedule_Id NUMBER(15);

Line 507: gms_awards_all aw --- Added for Bug#13370217

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
511: and su.project_id = bv.project_id