DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_K_LINES

Line 1513: FROM okl_k_lines

1509: END IF;
1510:
1511: SELECT NVL(amount, 0)
1512: INTO l_line_amount
1513: FROM okl_k_lines
1514: WHERE id = p_cle_id;
1515:
1516: SELECT currency_code
1517: INTO l_currency_code

Line 1536: FROM okl_k_lines

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

Line 1559: FROM okl_k_lines

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

Line 3197: FROM OKL_K_LINES

3193: l_top_line_id := p_clev_fin_rec.id;
3194: l_dnz_chr_id := p_clev_fin_rec.dnz_chr_id;
3195: SELECT oec
3196: INTO l_oec
3197: FROM OKL_K_LINES
3198: WHERE ID = p_clev_fin_rec.id;
3199: l_down_payment_receiver := 'LESSOR';
3200: FOR l_asset_dp_rec IN get_asset_dp_details(p_asset_id) LOOP
3201: l_dp_exists := TRUE;