APPS.AR_ARXSOC2_XMLP_PKG SQL Statements

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

Line: 33

    SELECT SUBSTR(cp.user_concurrent_program_name, 1, 80)
    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: 110

select  count (*)
  into l_bank_count
from  ce_bank_accounts cba,
      ce_bank_acct_uses ba,
      ce_bank_branches_v bb
where ba.bank_acct_use_id in
     (select distinct remit_bank_acct_use_id from ar_cash_receipts)
and  cba.bank_branch_id = bb.branch_party_id
and  cba.bank_account_name
    between decode(p_bank_account_name_low,
		   NULL, cba.bank_account_name,
			  p_bank_account_name_low)
    and     decode(p_bank_account_name_high,
		   NULL, cba.bank_account_name,
		   p_bank_account_name_high)
;

Line: 147

select
  decode(cr_status, 'REV', 0, amount),
  decode(cr_status, 'UNID', amount, 0),
  decode(cr_type,
         'MISC', decode(cr_status,
                        'REV', 0,
                              amount),
                 0),
  decode(cr_status, reversal_category,
         decode(cr_status, 'NSF', amount, 'STOP', amount, 0), 0),
  decode(cr_status, 'APP', 1, 0),
  decode(cr_status, 'UNAPP', 1, 0),
  decode(cr_status, 'UNID', 1, 0),
  decode(cr_type,
         'MISC', decode(cr_status,
                        'REV', 0,
                               1),
                 0)
into
  l_actual_amount,
  l_unidentified_amount,
  l_misc_amount,
  l_nsf_amount,
  l_applied_count,
  l_unapplied_count,
  l_unidentified_count,
  l_misc_count
from dual;

Line: 176

    select sum(amount_applied)
    into   l_on_account_amount
    from   ar_receivable_applications
    where  cash_receipt_id = cash_receipt_id
    and    status = 'ACC';

Line: 220

select
  decode(cr_status_BB, 'REV', 0, amount_B),
  decode(cr_status_BB, 'UNID', amount_B, 0),
  decode(cr_type_B,
         'MISC', decode(cr_status_BB,
                        'REV', 0,
                               amount_B),
                 0),
  decode(cr_status_BB, reversal_category_B,
         decode(cr_status_BB, 'NSF', amount_B, 'STOP', amount_B, 0), 0),
  decode(cr_status_BB, 'APP', 1, 0),
  decode(cr_status_BB, 'UNAPP', 1, 0),
  decode(cr_status_BB, 'UNID', 1, 0),
  decode(cr_type_B,
         'MISC', decode(cr_status_BB,
                        'REV', 0,
                               1),
                 0)
into
  l_actual_amount,
  l_unidentified_amount,
  l_misc_amount,
  l_nsf_amount,
  l_applied_count,
  l_unapplied_count,
  l_unidentified_count,
  l_misc_count
from dual;

Line: 249

    select sum(amount_applied)
    into   l_on_account_amount
    from   ar_receivable_applications
    where  cash_receipt_id = cash_receipt_id_B
    and    status = 'ACC';

Line: 281

	select meaning
	into   l_order_by
	from   ar_lookups
	where  lookup_type = 'SORT_BY_ARXSOC2'
        and    lookup_code = PH_ORDER_BY ;