APPS.GMS_TRANSACTIONS_PUB dependencies on GMS_AWARDS

Line 303: from GMS_AWARDS a,

299: nvl(a.Preaward_Date,a.START_DATE_ACTIVE) awd_Date,
300: a.End_Date_Active,
301: a.Close_Date,
302: a.Status
303: from GMS_AWARDS a,
304: gms_fp_distributions b
305: where a.award_id = b.award_id
306: and b.funding_pattern_id = x_funding_pattern_id;
307:

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

Line 522: --from GMS_AWARDS_BASIC_V

518: and aw.status <> 'CLOSED'
519: and aw.award_template_flag = 'DEFERRED' ;
520:
521: --Select award_id
522: --from GMS_AWARDS_BASIC_V
523: --where project_id = P_Project_Id
524: --and task_id = P_Task_Id
525: --and award_id = P_award_id;
526: --and award_id = to_number(P_award_id);

Line 879: from gms_awards

875: select 'Y'
876: from dual
877: where exists
878: (select 1
879: from gms_awards
880: where award_number = X_award_number
881: and nvl(award_id,0) = nvl(l_award_id,0));
882:
883:

Line 1001: from gms_awards

997:
998: begin
999: select award_id
1000: into l_award_id
1001: from gms_awards
1002: where award_number = X_award_number;
1003:
1004: exception
1005: when no_data_found then