APPS.ARP_DEDUCTION dependencies on AR_DISTRIBUTIONS

Line 363: ,ar_distributions ard

359: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
360: ) IS
361: select ra.amount_applied
362: from ar_receivable_applications ra
363: ,ar_distributions ard
364: where ra.cash_receipt_id = p_cr_id
365: and ra.status = 'UNAPP'
366: and nvl(ra.confirmed_flag,'Y') = 'Y'
367: and ra.receivable_application_id = ard.source_id

Line 377: ,ar_distributions ard

373: ( p_cr_id ar_receivable_applications.cash_receipt_id%type
374: ) IS
375: select sum(ra.amount_applied)
376: from ar_receivable_applications ra
377: ,ar_distributions ard
378: where ra.cash_receipt_id = p_cr_id
379: and ra.status = 'UNAPP'
380: and nvl(ra.confirmed_flag,'Y') = 'Y'
381: and ra.receivable_application_id = ard.source_id

Line 1885: -- Create 'OTHER ACC' OR 'ACC' record accounting in ar_distributions

1881: -- ---------------------------------------------------------------------
1882: l_prev_app_id := l_ra_rec.receivable_application_id;
1883:
1884: -- ---------------------------------------------------------------------
1885: -- Create 'OTHER ACC' OR 'ACC' record accounting in ar_distributions
1886: -- ---------------------------------------------------------------------
1887: l_ae_doc_rec.document_type := 'RECEIPT';
1888: l_ae_doc_rec.document_id := l_ra_rec.cash_receipt_id;
1889: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1946: -- Create paired UNAPP record accounting in ar_distributions

1942: p_rec_unapp_id => l_ra_rec.receivable_application_id);
1943: --
1944:
1945: -- ---------------------------------------------------------------------
1946: -- Create paired UNAPP record accounting in ar_distributions
1947: -- ---------------------------------------------------------------------
1948: l_ae_doc_rec.source_id_old := l_prev_app_id;
1949: l_ae_doc_rec.source_id := l_ra_rec.receivable_application_id;
1950: l_ae_doc_rec.other_flag := 'PAIR';

Line 2028: from ar_distributions_all ard

2024: from ar_receivable_applications ra
2025: where ra.receivable_application_id = p_rapp_id
2026: and nvl(ra.confirmed_flag,'Y') = 'Y'
2027: and exists (select 'x'
2028: from ar_distributions_all ard
2029: where ard.source_table = 'RA'
2030: and ard.source_id = ra.receivable_application_id)
2031: UNION
2032: select ra.* --'UNAPP'

Line 2034: , ar_distributions ard

2030: and ard.source_id = ra.receivable_application_id)
2031: UNION
2032: select ra.* --'UNAPP'
2033: from ar_receivable_applications ra
2034: , ar_distributions ard
2035: where ra.receivable_application_id = ard.SOURCE_ID
2036: and nvl(ra.confirmed_flag,'Y') = 'Y'
2037: and ard.source_table = 'RA'
2038: and ard.source_id_secondary =