APPS.OKL_LA_TRADEIN_PVT dependencies on OKL_K_LINES

Line 168: FROM okl_k_lines

164: BEGIN
165:
166: SELECT NVL(amount, 0)
167: INTO l_line_amount
168: FROM okl_k_lines
169: WHERE id = p_cle_id;
170:
171: SELECT currency_code
172: INTO l_currency_code

Line 189: FROM okl_k_lines

185: IF l_link_asset_tbl.EXISTS(i) THEN
186:
187: SELECT NVL(oec, 0)
188: INTO l_asset_oec
189: FROM okl_k_lines
190: WHERE id = l_link_asset_tbl(i).fin_asset_id;
191:
192: l_oec_total := l_oec_total + l_asset_oec;
193:

Line 219: FROM okl_k_lines

215: -- LLA APIs ensure asset OEC and line amount are rounded
216:
217: SELECT NVL(oec, 0)
218: INTO l_asset_oec
219: FROM okl_k_lines
220: WHERE id = l_link_asset_tbl(i).fin_asset_id;
221:
222: IF l_link_asset_tbl.COUNT = 1 THEN
223:

Line 730: p_cle_id IN OKL_K_LINES.id%TYPE

726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_chr_id IN OKL_K_HEADERS.id%TYPE,
730: p_cle_id IN OKL_K_LINES.id%TYPE
731: )IS
732:
733: l_cap_amount NUMBER;
734:

Line 1612: FROM okl_k_lines

1608: IF l_asset_tbl.EXISTS(i) THEN
1609:
1610: SELECT NVL(oec, 0)
1611: INTO l_asset_oec
1612: FROM okl_k_lines
1613: WHERE id = l_asset_tbl(i).fin_asset_id;
1614:
1615: l_oec_total := l_oec_total + l_asset_oec;
1616:

Line 1632: FROM okl_k_lines

1628: -- LLA APIs ensure asset OEC and l_tradein_amount are rounded
1629:
1630: SELECT NVL(oec, 0)
1631: INTO l_asset_oec
1632: FROM okl_k_lines
1633: WHERE id = l_asset_tbl(i).fin_asset_id;
1634:
1635: IF l_asset_tbl.COUNT = 1 THEN
1636: