APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_LINE_STYLES_B

Line 1715: okc_line_styles_b style

1711: line.initial_direct_cost,
1712: line.fee_type
1713: FROM okc_k_headers_b head,
1714: okl_k_lines_full_v line,
1715: okc_line_styles_b style
1716: WHERE head.id = line.dnz_chr_id
1717: AND line.lse_id = style.id
1718: AND head.id = p_chr_id
1719: AND line.id = p_line_id;

Line 1748: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

1744: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1745: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1746: l_amount NUMBER;
1747: l_capital_amount NUMBER;
1748: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
1749: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE := null;
1750: l_cap_yn VARCHAR2(3);
1751: l_mult_factor NUMBER;
1752: l_line_amount NUMBER;

Line 2140: okc_line_styles_b style

2136:
2137: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2138: SELECT style.lty_code
2139: FROM okc_k_lines_b line,
2140: okc_line_styles_b style
2141: WHERE line.lse_id = style.id
2142: AND line.id = p_line_id;
2143:
2144: CURSOR pay_term_csr (p_id NUMBER,

Line 2184: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

2180: AND trunc(nvl(start_date_active,sysdate)) <= trunc(sysdate)
2181: AND trunc(nvl(end_date_active,sysdate+1)) > trunc(sysdate);
2182:
2183: l_id1 VARCHAR2(30);
2184: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
2185:
2186: BEGIN
2187:
2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;