APPS.AR_ARATAPPM_PKG dependencies on AR_CASH_REMIT_REFS

Line 26: from ar_cash_remit_refs_interim;

22: where organization_id = p_org_id;
23:
24: select count(distinct cash_receipt_id)
25: into l_no_receipts_processed
26: from ar_cash_remit_refs_interim;
27:
28: select count(*)
29: into l_no_remit_lines_processed
30: from ar_cash_remit_refs_interim;

Line 30: from ar_cash_remit_refs_interim;

26: from ar_cash_remit_refs_interim;
27:
28: select count(*)
29: into l_no_remit_lines_processed
30: from ar_cash_remit_refs_interim;
31:
32: select count(*)
33: into l_no_remit_lines_autoapply
34: FROM ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs

Line 34: FROM ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs

30: from ar_cash_remit_refs_interim;
31:
32: select count(*)
33: into l_no_remit_lines_autoapply
34: FROM ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs
35: where interim.remit_reference_id = refs.remit_reference_id
36: and refs.auto_applied = 'Y';
37:
38: if l_no_remit_lines_processed = 0 then

Line 47: from ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs

43: l_hit_ratio := (l_no_remit_lines_autoapply/l_no_remit_lines_processed)*100;
44:
45: select count(*)
46: into l_no_remit_lines_suggested
47: from ar_cash_remit_refs_interim interim, ar_cash_remit_refs refs
48: where interim.remit_reference_id = refs.remit_reference_id
49: and refs.auto_applied = 'N'
50: and exists ( select 'Suggestion_Created'
51: from ar_cash_recos recos