APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 5156: -- Source Table should be OKL_TXD_AR_LN_DTLS_B/OKL_TXL_ADJSTS_LNS_B

5152: END IF;
5153: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5154: 'Validation 1 Successfull !');
5155: -- Validation 2:
5156: -- Source Table should be OKL_TXD_AR_LN_DTLS_B/OKL_TXL_ADJSTS_LNS_B
5157: -- Comparing with the Upper(Source_table) as billing is passing the value in the
5158: -- lower cases currently, need to knock this upper once billing passes it correctly
5159: IF UPPER(p_rxlv_rec.source_table) NOT IN ( G_TXD_AR_LN_DTLS_B, G_TXL_ADJSTS_LNS_B )
5160: THEN

Line 5652: ,'OKL_TXD_AR_LN_DTLS_B' source_table

5648: -- sty_id, try_id
5649: CURSOR c_trx_ar_inv_lines_csr (p_header_source_id NUMBER)
5650: IS
5651: SELECT tld.id source_id
5652: ,'OKL_TXD_AR_LN_DTLS_B' source_table
5653: ,tld.khr_id khr_id
5654: ,tld.kle_id kle_id
5655: ,tld.sty_id sty_id
5656: ,tai.try_id try_id

Line 5659: ,okl_txd_ar_ln_dtls_b tld

5655: ,tld.sty_id sty_id
5656: ,tai.try_id try_id
5657: FROM okl_trx_ar_invoices_b tai
5658: ,okl_txl_ar_inv_lns_b til
5659: ,okl_txd_ar_ln_dtls_b tld
5660: WHERE tld.til_id_details = til.id
5661: AND til.tai_id = tai.id
5662: AND tai.id = p_header_source_id;
5663: