[Home] [Help]
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
3258: AND TCN.tcn_type IN ('TMT','ALT' , 'EVG')-- akrangan bug 5354501 fix added 'EVG'
3701: QTE.partial_yn partial_yn,
3702: QTE.consolidated_yn consolidated_yn,
3703: QTE.qst_code qst_code,
3704: QTE.qtp_code qtp_code
3705: FROM OKL_TRX_QUOTES_B QTE,
3706: OKL_TXL_QTE_LINES_ALL_B TQL,
3707: OKC_K_LINES_B KLE,
3708: OKC_K_HEADERS_ALL_B KHR
3709: WHERE TQL.kle_id = KLE.id
3823:
3824: -- rmunjulu bug 4699340
3825: CURSOR get_qte_date_csr (p_quote_id IN NUMBER) IS
3826: SELECT date_effective_from
3827: FROM OKL_TRX_QUOTES_B
3828: WHERE id = p_quote_id;
3829:
3830: -- Start : Bug 6030917 : prasjain
3831: l_proration_factor NUMBER;
4054: QTE.partial_yn partial_yn,
4055: QTE.consolidated_yn consolidated_yn,
4056: QTE.qst_code qst_code,
4057: QTE.qtp_code qtp_code
4058: FROM OKL_TRX_QUOTES_B QTE,
4059: OKC_K_HEADERS_B KHR
4060: WHERE qte.khr_id = khr.id
4061: AND qte.khr_id = p_khr_id
4062: AND QTE.qtp_code LIKE 'TER%';
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
4152: AND trn.qte_id = qte.id
4261: AND b.book_class = 'CORPORATE';
4262:
4263: l_date_terminated DATE;
4264: l_quote_id NUMBER;
4265: l_quote_type OKL_TRX_QUOTES_B.qtp_code%TYPE;
4266: l_asset_residual NUMBER;
4267: l_deprn_amt NUMBER;
4268: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
4269: l_cost NUMBER;