APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 728: okl_txl_ar_inv_lns_b til,

724: --start changed by abhsaxen for Bug#6174484
725: SELECT st.khr_id contract_id,
726: cn.contract_number
727: FROM okl_xtl_sell_invs_v xls,
728: okl_txl_ar_inv_lns_b til,
729: okl_trx_ar_invoices_b tai,
730: okc_k_headers_all_b cn,
731: ar_payment_schedules_all ps,
732: ar_receivable_applications_all arapp,

Line 766: okl_txl_ar_inv_lns_b til,

762: --start changed by abhsaxen for Bug#6174484
763: SELECT st.khr_id contract_id,
764: cn.contract_number
765: FROM okl_xtl_sell_invs_v xls,
766: okl_txl_ar_inv_lns_b til,
767: okl_trx_ar_invoices_b tai,
768: okc_k_headers_b cn,
769: ar_payment_schedules_all ps,
770: ar_receivable_applications_all arapp,

Line 1766: okl_txl_ar_inv_lns_b til,

1762: tai.amount,
1763: tai.currency_code
1764: from
1765: okl_trx_ar_invoices_b tai,
1766: okl_txl_ar_inv_lns_b til,
1767: okl_cure_refunds crf
1768: where tai.id =til.tai_id
1769: and tai.id =crf.tai_id
1770: and crf.cure_refund_header_id =p_refund_header_id;*/

Line 1782: okl_txl_ar_inv_lns_b til,

1778: tai.date_invoiced date_invoiced,
1779: tai.amount amount,
1780: tai.currency_code currency_code
1781: from okl_trx_ar_invoices_b tai,
1782: okl_txl_ar_inv_lns_b til,
1783: okl_txd_ar_ln_dtls_b txd,
1784: okl_cure_refunds crf
1785: where crf.cure_refund_header_id = p_refund_header_id
1786: and tai.id = crf.tai_id

Line 1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;

1791:
1792: -- ASHIM CHANGE - END
1793:
1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;

Line 1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;

1793:
1794: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1795: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
1796: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
1797: l_line_id okl_txl_ar_inv_lns_b.id%TYPE;
1798: l_khr_id okc_k_headers_b.id%TYPE;
1799: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
1800: l_amount okl_trx_ar_invoices_b.amount%TYPE;
1801:

Line 1944: -- l_dist_info_tbl(1).source_table := 'OKL_TXL_AR_INV_LNS_B';

1940: l_tmpl_identify_tbl(1).prior_year_yn := 'N';
1941:
1942: l_dist_info_tbl(1).source_id := j.txd_id;
1943: --start: cklee 06/28/07
1944: -- l_dist_info_tbl(1).source_table := 'OKL_TXL_AR_INV_LNS_B';
1945: l_dist_info_tbl(1).source_table := 'OKL_TXD_AR_LN_DTLS_B';
1946: --end: cklee 06/28/07
1947: l_dist_info_tbl(1).accounting_date := j.date_invoiced;
1948: l_dist_info_tbl(1).gl_reversal_flag :='N';