APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 1822: FROM ar_distributions_all

1818: END IF;
1819:
1820: SELECT sum(nvl(ACCTD_AMOUNT_CR,0) - nvl(ACCTD_AMOUNT_DR,0))
1821: INTO l_func_curr_line_amt_tbl(i)
1822: FROM ar_distributions_all
1823: WHERE source_id = l_trx_id_tbl(i)
1824: AND source_table = 'ADJ'
1825: AND ref_customer_trx_line_id = l_adj_trx_line_id_tbl(i)
1826: AND org_id = l_org_id_tbl(i);

Line 1840: FROM ar_distributions_all

1836: END IF;
1837:
1838: SELECT sum(nvl(ACCTD_AMOUNT_CR,0) - nvl(ACCTD_AMOUNT_DR,0))
1839: INTO l_func_curr_line_amt_tbl(i)
1840: FROM ar_distributions_all
1841: WHERE source_id = l_receivable_app_id_tbl(i)
1842: AND source_table = 'RA'
1843: AND source_type IN ('EDISC', 'UNEDISC')
1844: AND ref_customer_trx_line_id = l_adj_trx_line_id_tbl(i)