APPS.OKL_CURE_RECON_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 503: FROM okl_txl_ar_inv_lns_b

499:
500: CURSOR c_get_til_obj_ver ( p_tai_id IN NUMBER)
501: IS
502: SELECT object_version_number,id
503: FROM okl_txl_ar_inv_lns_b
504: WHERE tai_id = p_tai_id;
505:
506: CURSOR c_get_txd_obj_ver ( p_til_id_details IN NUMBER)
507: IS

Line 2053: ,okl_txl_ar_inv_lns_b til

2049: ,tai.khr_id
2050: ,tai.date_invoiced
2051: ,tai.amount
2052: FROM okl_trx_ar_invoices_b tai
2053: ,okl_txl_ar_inv_lns_b til
2054: ,okl_txd_ar_ln_dtls_b tld
2055: WHERE tai.cpy_id = p_cam_id
2056: AND tai.id = til.tai_id
2057: AND tld.til_id_details = til.id;

Line 2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;

2056: AND tai.id = til.tai_id
2057: AND tld.til_id_details = til.id;
2058:
2059: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;
2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;