DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_K_LINES

Line 1517: FROM okl_k_lines

1513: END IF;
1514:
1515: SELECT NVL(amount, 0)
1516: INTO l_line_amount
1517: FROM okl_k_lines
1518: WHERE id = p_cle_id;
1519:
1520: SELECT currency_code
1521: INTO l_currency_code

Line 1540: FROM okl_k_lines

1536: IF l_link_asset_tbl.EXISTS(i) THEN
1537:
1538: SELECT NVL(oec, 0)
1539: INTO l_asset_oec
1540: FROM okl_k_lines
1541: WHERE id = l_link_asset_tbl(i).fin_asset_id;
1542: l_oec_total := l_oec_total + l_asset_oec;
1543: END IF;
1544: END LOOP;

Line 1563: FROM okl_k_lines

1559:
1560: -- LLA APIs ensure asset OEC and line amount are rounded
1561: SELECT NVL(oec, 0)
1562: INTO l_asset_oec
1563: FROM okl_k_lines
1564: WHERE id = l_link_asset_tbl(i).fin_asset_id;
1565: IF l_link_asset_tbl.COUNT = 1 THEN
1566: l_assoc_amount := l_line_amount;
1567: ELSE

Line 3235: FROM OKL_K_LINES

3231: l_top_line_id := p_clev_fin_rec.id;
3232: l_dnz_chr_id := p_clev_fin_rec.dnz_chr_id;
3233: SELECT oec
3234: INTO l_oec
3235: FROM OKL_K_LINES
3236: WHERE ID = p_clev_fin_rec.id;
3237: l_down_payment_receiver := 'LESSOR';
3238: FOR l_asset_dp_rec IN get_asset_dp_details(p_asset_id) LOOP
3239: l_dp_exists := TRUE;