APPS.GMS_TRANSACTIONS_PUB dependencies on GMS_AWARDS

Line 300: from GMS_AWARDS a,

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

Line 480: from GMS_AWARDS

476: nvl(Preaward_Date,START_DATE_ACTIVE),
477: End_Date_Active,
478: Close_Date,
479: Status
480: from GMS_AWARDS
481: where award_id = P_award_id;
482: --where award_id = to_number( P_award_id);
483:
484: X_Allowable_Schedule_Id NUMBER(15);

Line 501: gms_awards aw

497: from pa_tasks t ,
498: gms_installments ins,
499: gms_summary_project_fundings su,
500: gms_budget_versions bv,
501: gms_awards aw
502: where bv.budget_status_code = 'B'
503: and bv.project_id = P_Project_Id
504: and bv.award_id = P_award_id
505: and su.project_id = bv.project_id

Line 516: --from GMS_AWARDS_BASIC_V

512: and aw.status <> 'CLOSED'
513: and aw.award_template_flag = 'DEFERRED' ;
514:
515: --Select award_id
516: --from GMS_AWARDS_BASIC_V
517: --where project_id = P_Project_Id
518: --and task_id = P_Task_Id
519: --and award_id = P_award_id;
520: --and award_id = to_number(P_award_id);

Line 863: from gms_awards

859: select 'Y'
860: from dual
861: where exists
862: (select 1
863: from gms_awards
864: where award_number = X_award_number
865: and nvl(award_id,0) = nvl(l_award_id,0));
866:
867:

Line 985: from gms_awards

981:
982: begin
983: select award_id
984: into l_award_id
985: from gms_awards
986: where award_number = X_award_number;
987:
988: exception
989: when no_data_found then