APPS.OKL_AM_UTIL_PVT dependencies on OKL_TRX_CONTRACTS

Line 3152: from okl_trx_contracts tcn,

3148: qteb.quote_number quote_number,
3149: qteb.partial_yn partial_yn,
3150: qteb.qst_code qst_code,
3151: qteb.qtp_code qtp_code
3152: from okl_trx_contracts tcn,
3153: okl_trx_quotes_all_b qteb,
3154: okl_trx_quotes_tl qte,
3155: okc_k_headers_all_b khr
3156: where tcn.khr_id = khr.id

Line 3253: FROM OKL_TRX_CONTRACTS TCN,

3249: QTE.quote_number quote_number,
3250: QTE.partial_yn partial_yn,
3251: QTE.qst_code qst_code,
3252: QTE.qtp_code qtp_code
3253: FROM OKL_TRX_CONTRACTS TCN,
3254: OKL_TRX_QUOTES_B QTE,
3255: OKL_TXL_QUOTE_LINES_B TQL
3256: WHERE TCN.qte_id = QTE.id
3257: AND TQL.qte_id = QTE.id

Line 3358: FROM OKL_TRX_CONTRACTS TRX

3354:
3355: -- Get the transaction for the quote -- both full and partial
3356: CURSOR get_trn_csr ( p_qte_id IN NUMBER) IS
3357: SELECT TRX.id id
3358: FROM OKL_TRX_CONTRACTS TRX
3359: WHERE TRX.tcn_type IN ('TMT','ALT' , 'EVG')-- akrangan bug 5354501 fix added 'EVG'
3360: --rkuttiya added for 12.1.1 multi gaap
3361: AND TRX.representation_type = 'PRIMARY'
3362: --

Line 4147: FROM OKL_TRX_CONTRACTS trn,

4143: SELECT qte.id,
4144: qte.qtp_code, -- quote type
4145: qte.date_accepted, -- quote acceptance date
4146: nvl(tql.asset_value,0) net_investment -- rmunjulu 4399736
4147: FROM OKL_TRX_CONTRACTS trn,
4148: OKL_TRX_QUOTES_B qte,
4149: OKL_TXL_QUOTE_LINES_B tql
4150: WHERE trn.khr_id = p_khr_id
4151: AND trn.tmt_status_code <> 'CANCELED' --akrangan changed tsu_code to tmt_status_code

Line 4881: FROM OKL_TRX_CONTRACTS

4877: CURSOR get_termination_trn_csr (p_khr_id IN NUMBER) IS
4878: SELECT 'Y'
4879: FROM DUAL
4880: WHERE EXISTS (SELECT id
4881: FROM OKL_TRX_CONTRACTS
4882: WHERE khr_id = p_khr_id
4883: AND tmt_status_code NOT IN ('PROCESSED', 'CANCELED') --akrangan changed
4884: --tsu_code to tmt_status_code
4885: AND tcn_type IN ('TMT')