APPS.ARRX_RC SQL Statements

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

Line: 152

   select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
   into var.chart_of_accounts_id,var.currency_code,var.org_name
   from GL_SETS_OF_BOOKS
   where SET_OF_BOOKS_ID = var.books_id;

Line: 565

     select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
     into var.p_coa_id,var.functional_currency_code,var.organization_name
     from GL_SETS_OF_BOOKS
     where SET_OF_BOOKS_ID =nvl( var.p_sob_id,var.books_id);

Line: 643

                 (SELECT ''App Exists''
                  FROM     AR_RECEIVABLE_APPLICATIONS_ALL RA
                  WHERE CR.CASH_RECEIPT_ID            = RA.CASH_RECEIPT_ID
                  AND   CR.TYPE                       = ''CASH''
                  AND   NVL(RA.CONFIRMED_FLAG, ''Y'') = ''Y''
                  AND   RA.GL_DATE                    < :p_gl_date_low ' || L_RA_ORG_WHERE ||
                 ')
                AND NOT EXISTS
                 (SELECT ''App Exists''
                  FROM   AR_MISC_CASH_DISTRIBUTIONS_ALL MISC
                  WHERE  CR.CASH_RECEIPT_ID    = MISC.CASH_RECEIPT_ID
                  AND    CR.TYPE              = ''MISC''
                  AND    MISC.GL_DATE         < :p_gl_date_low ' || L_MISC_ORG_WHERE ||
                 ')
                OR CRH.STATUS = ''REVERSED'' )';

Line: 668

                             SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
                               FROM AR_CASH_RECEIPT_HISTORY_ALL INCRH
                              WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
                                AND INCRH.STATUS <> ''REVERSED'' ' ||
                             INCRH_GL_DATE_WHERE ||
                             L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;

Line: 679

                             SELECT MAX(INCRH.CASH_RECEIPT_HISTORY_ID)
                               FROM AR_CASH_RECEIPT_HIST_ALL_MRC_V INCRH
                              WHERE INCRH.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
                             AND INCRH.STATUS <> ''REVERSED'' ' ||
                             INCRH_GL_DATE_WHERE ||
                             L_INCRH_ORG_WHERE || ' )))' || CO_SEG_WHERE;

Line: 1206

   select MEANING into L_CASH       from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE'   and lookup_code='CASH';

Line: 1207

   select MEANING into L_MISC       from ar_lookups where lookup_type='PAYMENT_CATEGORY_TYPE'   and lookup_code='MISC';

Line: 1208

   select MEANING into var.l_app    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='APP';

Line: 1209

   select MEANING into var.l_nsf    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='NSF';

Line: 1210

   select MEANING into var.l_rev    from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='REV';

Line: 1211

   select MEANING into var.l_stop   from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='STOP';

Line: 1212

   select MEANING into var.l_unapp  from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='UNAPP';

Line: 1213

   select MEANING into var.l_unid   from ar_lookups where lookup_type='CHECK_STATUS'            and lookup_code='UNID';

Line: 1214

   select MEANING into L_PAYMENT    from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='PAYMENT';

Line: 1215

   select MEANING into L_RECEIPT    from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='RECEIPT';

Line: 1216

   select MEANING into L_REMITTANCE from ar_lookups where lookup_type='CB_REFERENCE_TYPE'       and lookup_code='REMITTANCE';

Line: 1217

   select MEANING into L_APPROVED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';

Line: 1218

   select MEANING into L_CLEARED    from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CLEARED';

Line: 1219

   select MEANING into L_CONFIRMED  from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='CONFIRMED';

Line: 1220

   select MEANING into L_REMITTED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';

Line: 1221

   select MEANING into L_REVERSED   from ar_lookups where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';

Line: 1244

      select MEANING into L_ACCO   from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='ACC';

Line: 1245

      select MEANING into L_APPL   from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='APP';

Line: 1246

      select MEANING into L_UNAPPL from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNAPP';

Line: 1247

      select MEANING into L_UNIDE  from ar_lookups where lookup_type='PAYMENT_TYPE' and lookup_code='UNID';

Line: 1259

      SELECT substrb(meaning,1,20) INTO L_ONACCOUNT FROM ar_lookups WHERE lookup_type='PAYMENT_TYPE' AND lookup_code='ACC';

Line: 1300

         select decode(
                    sum(decode(status,'UNID', amount_applied,0)),
                    0,
                    decode(sum(decode(status,'UNAPP', amount_applied,0))
                    , 0 , var.l_app , var.l_unapp),
                    var.l_unid)
         into var.receipt_status
         from ar_receivable_applications
         where cash_receipt_id = var.cash_receipt_id;

Line: 1313

        select decode(
                    sum(decode(status,'UNID', amount_applied,0)),
                    0,
                    decode(sum(decode(status,'UNAPP', amount_applied,0))
                    , 0 , var.l_app , var.l_unapp),
                    var.l_unid)
        into var.receipt_status
        from ar_receivable_apps_mrc_v
        where cash_receipt_id = var.cash_receipt_id;

Line: 1458

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1500

    select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
    into  l_client_info_rsob_id
    from  dual;

Line: 1523

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1616

    select set_of_books_id
     into   var.books_id
     from  ar_system_parameters_all
     where org_id = var.p_reporting_entity_id;

Line: 1626

   select to_number(nvl(replace(substr(userenv('CLIENT_INFO'),45,10),' '),-99))
   into  l_client_info_rsob_id from  dual;

Line: 1650

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1720

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1761

  SELECT TO_NUMBER(NVL( REPLACE(SUBSTRB(USERENV('CLIENT_INFO'),45,10),' '),-99))
  INTO l_client_info_rsob_id
  FROM dual;

Line: 1785

                'arrx_rc.bind(:CURSOR_SELECT);',

Line: 1867

   select set_of_books_id
    into   var.books_id
    from  ar_system_parameters_all
    where org_id = p_reporting_entity_id;

Line: 1889

                'arrx_rc.bind(:CURSOR_SELECT);',