APPS.AR_RAXGLR_XMLP_PKG SQL Statements

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

Line: 37

		p_select_1 := ' sum(decode(sign(gl_dist.amount),
                  				 1, round(gl_dist.amount, 2), NULL)) curr_credit_amount,
        			 sum(decode(sign(gl_dist.amount),
                   				-1, -round(gl_dist.amount, 2), NULL)) curr_debit_amount ' ;

Line: 81

   select chart_of_accounts_id
     into p_coaid
     from  ar_system_parameters,
           gl_sets_of_books
    where ar_system_parameters.set_of_books_id =
          gl_sets_of_books.set_of_books_id;

Line: 139

 		select nvl(min(x.due_date), TO_DATE(''01/01/0001'',''MM/DD/YYYY''))
   		from ar_payment_schedules_all_mrc_v x
    		 where x.customer_trx_id = ps.customer_trx_id)
 			and ps.cons_inv_id = ci.cons_inv_id(+)';

Line: 147

 		select nvl(min(x.due_date), TO_DATE(''01/01/0001'',''MM/DD/YYYY''))
   		from ar_payment_schedules_all x
    		 where x.customer_trx_id = ps.customer_trx_id)
 			and ps.cons_inv_id = ci.cons_inv_id(+)';

Line: 171

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO L_REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 407

        SELECT
          MEANING
        INTO ACCT_MEANING
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'AUTOGL_TYPE'
          AND LOOKUP_CODE = P_GL_ACCOUNT_TYPE;

Line: 427

        SELECT
          MEANING
        INTO ORDER_MEANING
        FROM
          AR_LOOKUPS
        WHERE LOOKUP_TYPE = 'SORT_BY_RAXGLR'
          AND LOOKUP_CODE = P_SORT_BY;

Line: 446

      SELECT
        MEANING
      INTO STATUS_MEANING
      FROM
        AR_LOOKUPS
      WHERE LOOKUP_TYPE = 'POSTING_STATUS'
        AND LOOKUP_CODE = NVL(P_POSTING_STATUS
         ,'ALL');

Line: 472

  select lookup_code
     into l_code
     from fnd_lookups
    where meaning = p_reporting_level_name
      and lookup_type = 'XLA_MO_REPORTING_LEVEL' ;