APPS.OKL_CASH_RECEIPT dependencies on OKL_XTL_CSH_APPS_V

Line 274: FROM okl_xtl_csh_apps_v

270: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
271:
272: /* Modified select statement to address bug 4510824 */
273: SELECT max(trx_date), invoice_number INTO l_xcav_tbl(i).trx_date, ar_invoice_num
274: FROM okl_xtl_csh_apps_v
275: WHERE lsm_id = l_xcav_tbl(i).lsm_id
276: AND rca_id = l_xcav_tbl(i).rca_id
277: GROUP BY invoice_number;
278:

Line 827: FROM okl_xtl_csh_apps_v

823:
824: -- l_customer_trx_id := NULL;
825:
826: SELECT trx_date INTO l_xcav_tbl(i).trx_date
827: FROM okl_xtl_csh_apps_v
828: WHERE lsm_id = l_xcav_tbl(i).lsm_id
829: AND rca_id = l_xcav_tbl(i).rca_id;
830:
831: IF l_currency_code = l_xcrv_rec.currency_code THEN

Line 914: FROM okl_xtl_csh_apps_v

910: FROM okl_cnsld_ar_strms_v
911: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
912:
913: SELECT trx_date INTO l_xcav_tbl(i).trx_date
914: FROM okl_xtl_csh_apps_v
915: WHERE lsm_id = l_xcav_tbl(i).lsm_id
916: AND rca_id = l_xcav_tbl(i).rca_id;
917:
918: IF l_currency_code = l_xcrv_rec.currency_code THEN