APPS.AR_ARATAPPM_PKG SQL Statements

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

Line: 19

   select name
   into l_org_name
   from hr_operating_units
   where organization_id = p_org_id;

Line: 24

   select count(distinct cash_receipt_id)
   into l_no_receipts_processed
   from ar_cash_remit_refs_interim;

Line: 28

   select count(*)
   into l_no_remit_lines_processed
   from ar_cash_remit_refs_interim;

Line: 32

   select count(*)
   into l_no_remit_lines_autoapply
   FROM  ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs
   where interim.remit_reference_id = refs.remit_reference_id
   and refs.auto_applied = 'Y';

Line: 45

   select count(*)
   into l_no_remit_lines_suggested
   from ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs
   where interim.remit_reference_id = refs.remit_reference_id
   and refs.auto_applied = 'N'
   and exists ( select 'Suggestion_Created'
             from ar_cash_recos recos
             where recos.remit_reference_id = interim.remit_reference_id);