APPS.GMS_ACC_GEN_API SQL Statements

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

Line: 19

	SELECT award_id
      FROM gms_award_distributions
	 WHERE document_type = x_doc_type
	   and expenditure_item_id = x_exp_item_id
	   and nvl(cdl_line_num,1) = NVL(x_cdl_line_num,1)
	   and ADL_STATUS		   = 'A'  ;

Line: 84

    select  award_id
    from    gms_award_distributions
    where   award_set_id = p_award_set_id
    and     document_type = p_document_type
    and     adl_status = 'A'
    and     adl_line_num = 1;

Line: 92

    select  award_id
    from    gms_award_distributions
    where   award_set_id = p_award_set_id
--    and     adl_status = 'A' -- Bug 2930402 fix.
    and     adl_line_num = 1;

Line: 99

    select  default_dist_award_id
    from    gms_implementations;

Line: 225

    select  document_type
    from    gms_award_distributions
    where   award_set_id = p_award_set_id
    and     adl_status = 'A'
    and     adl_line_num = 1;

Line: 307

		SELECT award_id
		  INTO x_award_id
		  FROM gms_award_distributions
		 WHERE award_set_id	= x_award_set_id
		   and document_type	= x_doc_type
		   and adl_status		= 'A'
		   and adl_line_num		= 1 ;

Line: 337

		SELECT award_id
		  INTO x_award_id
		  FROM gms_award_distributions
		 WHERE expenditure_item_id	= NVL( x_exp_enc_item_id, 0)
		   AND nvl(cdl_line_num, 1)		= NVL(x_cdl_line,1) --Bug 5726575
		   AND document_type		= x_doc_type
		   and adl_status			= 'A' ;