APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 703: FROM OKL_TXL_QUOTE_LINES_B TQL

699:
700: -- Get the quote assets count
701: CURSOR get_quote_assets_no_csr (p_qte_id IN NUMBER) IS
702: SELECT COUNT(TQL.id) no_of_quote_assets
703: FROM OKL_TXL_QUOTE_LINES_B TQL
704: WHERE TQL.qlt_code = 'AMCFIA'
705: AND TQL.qte_id = p_qte_id;
706:
707: -- Get the contract assets count - All NON Terminated Financial Assets

Line 729: FROM OKL_TXL_QUOTE_LINES_B TQL

725: CURSOR get_asset_qty_csr (p_qte_id IN NUMBER) IS
726: SELECT TQL.kle_id,
727: TQL.asset_quantity,
728: TQL.quote_quantity
729: FROM OKL_TXL_QUOTE_LINES_B TQL
730: WHERE TQL.qlt_code = 'AMCFIA'
731: AND TQL.qte_id = p_qte_id;
732:
733: l_quote_assets_no NUMBER;

Line 836: FROM OKL_TXL_QUOTE_LINES_B TQL

832: CURSOR get_asset_qty_csr (p_qte_id IN NUMBER) IS
833: SELECT TQL.kle_id,
834: TQL.asset_quantity,
835: TQL.quote_quantity
836: FROM OKL_TXL_QUOTE_LINES_B TQL
837: WHERE TQL.qlt_code = 'AMCFIA'
838: AND TQL.qte_id = p_qte_id;
839:
840: -- get any additional assets on contract which are non terminated and not in quote

Line 853: FROM OKL_TXL_QUOTE_LINES_B

849: AND CHR.id = CLE.dnz_chr_id
850: AND CLE.dnz_chr_id = p_khr_id
851: AND CLE.id NOT IN
852: (SELECT kle_id
853: FROM OKL_TXL_QUOTE_LINES_B
854: WHERE qte_id = p_qte_id
855: AND qlt_code = 'AMCFIA');
856:
857: l_quote_assets_no NUMBER;