1379: -- NET_INVESTMENT,
1380: -- 17-Dec-08 Seema Chawla - bug 7635398 : changed Named parameter passing notation to Positional notation
1381: /*
1382:
1383: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
1384: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
1385:
1386: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
1387: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1382:
1383: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
1384: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
1385:
1386: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
1387: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1388: */
1389:
1390: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
1386: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
1387: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1388: */
1389:
1390: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
1391: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
1392:
1393: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
1394: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1389:
1390: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
1391: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
1392:
1393: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
1394: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
1395:
1396: decode(cle.lse_id,33,
1397: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
3495: --LINE_CAP_AMOUNT,
3496: -- NET_INVESTMENT,
3497: -- 17-Dec-08 Seema Chawla - bug 7635398 : changed Named parameter passing notation to Positional notation
3498:
3499: /* NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
3500: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
3501:
3502: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
3503: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3498:
3499: /* NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
3500: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
3501:
3502: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
3503: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3504: */
3505: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
3506: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
3501:
3502: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
3503: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3504: */
3505: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
3506: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
3507:
3508: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
3509: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3504: */
3505: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
3506: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
3507:
3508: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
3509: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
3510:
3511: decode(cle.lse_id,33,
3512: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,
5520: --LINE_BILLED_NON_RENTS_FUNC,
5521: --LINE_CAP_AMOUNT,
5522: -- NET_INVESTMENT,
5523: -- 17-Dec-08 Seema Chawla - bug 7635398 : changed Named parameter passing notation to Positional notation
5524: /* NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
5525: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
5526:
5527: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
5528: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5523: -- 17-Dec-08 Seema Chawla - bug 7635398 : changed Named parameter passing notation to Positional notation
5524: /* NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id => cle.dnz_chr_id,
5525: p_kle_id => cle.id, p_ref_type_code => 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
5526:
5527: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
5528: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5529: */
5530: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
5531: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
5526:
5527: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(p_khr_id =>cle.dnz_chr_id,
5528: p_kle_id => cle.id, p_ref_type_code => 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5529: */
5530: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
5531: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
5532:
5533: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
5534: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5529: */
5530: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt( cle.dnz_chr_id,
5531: cle.id, 'ASSET'),null) ASSETS_FUNDED_AMOUNT,
5532:
5533: NVL(OKL_FUNDING_PVT.get_contract_line_funded_amt(cle.dnz_chr_id,
5534: cle.id, 'EXPENSE'),null) EXPENSE_FUNDED_AMOUNT,
5535:
5536: decode(cle.lse_id,33,
5537: NVL(OKL_SEEDED_FUNCTIONS_PVT.total_asset_addon_cost (cle.dnz_chr_id,cle.id),0),null) TOTAL_ASSET_ADDON_COST,