677:
678: -- Get the quote assets count
679: CURSOR get_quote_assets_no_csr (p_qte_id IN NUMBER) IS
680: SELECT COUNT(TQL.id) no_of_quote_assets
681: FROM OKL_TXL_QUOTE_LINES_B TQL
682: WHERE TQL.qlt_code = 'AMCFIA'
683: AND TQL.qte_id = p_qte_id;
684:
685: -- Get the contract assets count - All NON Terminated Financial Assets
703: CURSOR get_asset_qty_csr (p_qte_id IN NUMBER) IS
704: SELECT TQL.kle_id,
705: TQL.asset_quantity,
706: TQL.quote_quantity
707: FROM OKL_TXL_QUOTE_LINES_B TQL
708: WHERE TQL.qlt_code = 'AMCFIA'
709: AND TQL.qte_id = p_qte_id;
710:
711: l_quote_assets_no NUMBER;
810: CURSOR get_asset_qty_csr (p_qte_id IN NUMBER) IS
811: SELECT TQL.kle_id,
812: TQL.asset_quantity,
813: TQL.quote_quantity
814: FROM OKL_TXL_QUOTE_LINES_B TQL
815: WHERE TQL.qlt_code = 'AMCFIA'
816: AND TQL.qte_id = p_qte_id;
817:
818: -- get any additional assets on contract which are non terminated and not in quote
827: AND CHR.id = CLE.dnz_chr_id
828: AND CLE.dnz_chr_id = p_khr_id
829: AND CLE.id NOT IN
830: (SELECT kle_id
831: FROM OKL_TXL_QUOTE_LINES_B
832: WHERE qte_id = p_qte_id
833: AND qlt_code = 'AMCFIA');
834:
835: l_quote_assets_no NUMBER;