APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_ASSETS

Line 250: CURSOR c_tas_khr_id_csr( p_source_id okl_trx_assets.id%TYPE )

246: AND TRY_B.ID = try_tl.id
247: AND try_tl.language = p_led_lang;
248:
249: -- Cursor to fetch the Contract Id from the OKL_TXL_ASSETS table.
250: CURSOR c_tas_khr_id_csr( p_source_id okl_trx_assets.id%TYPE )
251: IS
252: SELECT DISTINCT tal.dnz_khr_id khr_id
253: ,kle_id kle_id
254: FROM okl_trx_assets tas

Line 254: FROM okl_trx_assets tas

250: CURSOR c_tas_khr_id_csr( p_source_id okl_trx_assets.id%TYPE )
251: IS
252: SELECT DISTINCT tal.dnz_khr_id khr_id
253: ,kle_id kle_id
254: FROM okl_trx_assets tas
255: ,okl_txl_assets_b tal
256: WHERE tal.tas_id = tas.id
257: AND tas.id = p_source_id;
258:

Line 482: FROM okl_trx_assets tas

478: IS
479: SELECT tas.trans_number trans_number
480: ,txl.id txl_id
481: ,tas.id tas_id
482: FROM okl_trx_assets tas
483: ,okl_txl_assets_b txl
484: WHERE tas.id = txl.tas_id and
485: txl.id = p_source_id;
486:

Line 494: FROM okl_trx_assets tas

490: IS
491: SELECT tas.trans_number trans_number
492: ,txl.id txl_id
493: ,tas.id tas_id
494: FROM okl_trx_assets tas
495: ,okl_txl_assets_b txl
496: ,okl_txd_assets_b txd
497: WHERE tas.id = txl.tas_id and
498: txl.id = txd.tal_id and

Line 694: FROM okl_trx_assets tas

690: AND tql.kle_id = p_kle_id
691: AND EXISTS
692: (
693: SELECT 1
694: FROM okl_trx_assets tas
695: ,okl_txl_assets_b tal
696: ,okc_k_lines_b cleb
697: WHERE cleb.id = tql.kle_id
698: AND cleb.cle_id = tal.kle_id

Line 2840: -- Eg. OKL_TRX_CONTRACTS, OKL_TRX_ASSETS ..

2836: -- IN : p_source_id IN NUMBER Required
2837: -- Pass Transaction Header id.
2838: -- p_source_hdr_table IN VARCHAR2 Required
2839: -- Pass the table name of the Transaction Header.
2840: -- Eg. OKL_TRX_CONTRACTS, OKL_TRX_ASSETS ..
2841: -- p_trans_line_tbl trans_line_tbl_type Required.
2842: -- source_line_id NUMBER Required
2843: -- Pass the Transaction Line id
2844: -- source_line_table VARCHAR2(30) Required