APPS.ARRX_RC_UNAPP SQL Statements

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

Line: 109

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

Line: 132

           bind is assigned 'arrx_rc_unapp.bind(:CURSOR_SELECT);'

Line: 136

           The bind trigger requires one host variable ':CURSOR_SELECT'.
     */
     fa_rx_util_pkg.debug('Assigning the report triggers');

Line: 142

                                  'arrx_rc_unapp.bind(:CURSOR_SELECT);',

Line: 195

     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 = var.p_sob_id;

Line: 378

     /* Assign the Select List */
     fa_rx_util_pkg.debug('Assign Select List');

Line: 669

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

Line: 671

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

Line: 673

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

Line: 675

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

Line: 677

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

Line: 679

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

Line: 688

      select substr(MEANING,1,44) into l_unid_cust from ar_lookups
      where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';

Line: 693

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

Line: 695

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

Line: 697

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

Line: 699

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

Line: 701

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