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 1881: -- Create 'OTHER ACC' OR 'ACC' record accounting in ar_distributions

1877: -- ---------------------------------------------------------------------
1878: l_prev_app_id := l_ra_rec.receivable_application_id;
1879:
1880: -- ---------------------------------------------------------------------
1881: -- Create 'OTHER ACC' OR 'ACC' record accounting in ar_distributions
1882: -- ---------------------------------------------------------------------
1883: l_ae_doc_rec.document_type := 'RECEIPT';
1884: l_ae_doc_rec.document_id := l_ra_rec.cash_receipt_id;
1885: l_ae_doc_rec.accounting_entity_level := 'ONE';

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

1938: p_rec_unapp_id => l_ra_rec.receivable_application_id);
1939: --
1940:
1941: -- ---------------------------------------------------------------------
1942: -- Create paired UNAPP record accounting in ar_distributions
1943: -- ---------------------------------------------------------------------
1944: l_ae_doc_rec.source_id_old := l_prev_app_id;
1945: l_ae_doc_rec.source_id := l_ra_rec.receivable_application_id;
1946: l_ae_doc_rec.other_flag := 'PAIR';

Line 2024: from ar_distributions_all ard

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

Line 2030: , ar_distributions ard

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