APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1319: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1315:
1316: BEGIN
1317: SELECT SUM(nvl(amount_applied,0)) ,sum(nvl(tax_applied,0))
1318: INTO l_amount_recvd_tbl(p_trx_id_tbl(i)),l_tax_amount_rcvd_tbl(p_trx_id_tbl(i))
1319: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1320: WHERE applied_customer_trx_id = p_trx_id_tbl(i)
1321: AND org_id = p_org_id_tbl(i)
1322: AND status = 'APP'
1323: AND application_type = 'CASH';

Line 1867: FROM ar_receivable_applications_all

1863:
1864: BEGIN
1865: SELECT apply_date
1866: INTO l_disc_apply_date_tbl(i)
1867: FROM ar_receivable_applications_all
1868: WHERE cash_receipt_id = l_trx_id_tbl(i)
1869: AND status ='APP'
1870: AND applied_customer_trx_id = l_adj_trx_id_tbl(i)
1871: AND org_id = l_org_id_tbl(i) ;

Line 2785: ar_receivable_applications_all cash

2781: l_detail_tax_line_id_tbl,
2782: l_trx_id_tbl,
2783: l_org_id_tbl
2784: FROM zx_rep_trx_detail_t dtl ,
2785: ar_receivable_applications_all cash
2786: WHERE dtl.request_id = p_request_id
2787: AND dtl.trx_id = cash.applied_customer_trx_id
2788: AND cash.status = 'APP'
2789: AND cash.application_type = 'CASH';