APPS.GMS_PA_XFACE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

	SELECT 'X'
	FROM pa_projects p,
	     gms_project_types gpt
        WHERE p.project_id  	=  x_project_id
	AND   p.project_type	= gpt.project_type
	AND   gpt.sponsored_flag= 'Y'  ;

Line: 70

 SELECT * from pa_expenditure_items_all
 WHERE adjusted_expenditure_item_id = x_expenditure_item_id ;

Line: 74

 SELECT * from pa_expenditure_items_all
 WHERE transferred_from_exp_item_id = x_expenditure_item_id ;

Line: 82

  select award_id , bill_hold_flag into source_award_id ,x_flag from gms_award_distributions adl
  where adl.expenditure_item_id = x_expenditure_item_id
  and adl.document_type = 'EXP' ;

Line: 105

       adl_rec.last_update_date    	 := rev_rec.last_update_date;

Line: 107

       adl_rec.last_updated_by        	 := rev_rec.last_updated_by;

Line: 109

       adl_rec.last_update_login   	 := rev_rec.last_update_login;

Line: 129

       adl_rec.last_update_date    	 := new_rec.last_update_date;

Line: 131

       adl_rec.last_updated_by        	 := new_rec.last_updated_by;

Line: 133

       adl_rec.last_update_login   	 := new_rec.last_update_login;

Line: 153

      select expenditure_type
      from gms_allowable_expenditures
      where allowability_schedule_id = x_allowable_id
      and expenditure_type = x_expenditure_type;

Line: 179

       select allowable_schedule_id ,end_date_active from gms_awards_all
       where award_id = dest_award_id ;

Line: 183

      select expenditure_type,expenditure_item_date
      from pa_expenditure_items_all
      where expenditure_item_id = x_expenditure_item_id;

Line: 217

        select CDL.system_reference2 ,  -- AP INVOICE_ID
	       CDL.system_reference3    -- AP DIST LINE NUM
	from  pa_cost_distribution_lines     CDL,
	      ap_invoice_distributions       ADL
        where CDL.expenditure_item_id  = X_expenditure_item_id
	and   CDL.system_reference2    = ADL.invoice_id
	and   CDL.system_reference3    = ADL.distribution_line_number
	and   ADL.attribute6          IS NULL
	and   CDL.line_num	       = 1
	and   CDL.system_reference2   IS NOT NULL
	and   CDL.system_reference3   IS NOT NULL;

Line: 296

 SELECT * from pa_expenditure_items_all
 WHERE adjusted_expenditure_item_id = x_exp_item_id ;

Line: 300

 SELECT * from pa_expenditure_items_all
 WHERE transferred_from_exp_item_id = x_exp_item_id ;

Line: 312

	  select bill_hold_flag, award_id  into x_flag, source_award_id  from gms_award_distributions
  	  where expenditure_item_id = x_exp_item_id
  	  and award_id = source_award_id
	  and document_type = 'EXP'  ;

Line: 336

       adl_rec.last_update_date    	 := rev_rec.last_update_date;

Line: 338

       adl_rec.last_updated_by        	 := rev_rec.last_updated_by;

Line: 340

       adl_rec.last_update_login   	 := rev_rec.last_update_login;

Line: 360

       adl_rec.last_update_date    	 := new_rec.last_update_date;

Line: 362

       adl_rec.last_updated_by        	 := new_rec.last_updated_by;

Line: 364

       adl_rec.last_update_login   	 := new_rec.last_update_login;