APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_LINE_STYLES_B

Line 1770: okc_line_styles_b style

1766: line.initial_direct_cost,
1767: line.fee_type
1768: FROM okc_k_headers_b head,
1769: okl_k_lines_full_v line,
1770: okc_line_styles_b style
1771: WHERE head.id = line.dnz_chr_id
1772: AND line.lse_id = style.id
1773: AND head.id = p_chr_id
1774: AND line.id = p_line_id;

Line 1803: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

1799: l_start_date OKC_K_lineS_B.START_DATE%TYPE;
1800: l_end_date OKC_K_lineS_B.END_DATE%TYPE;
1801: l_amount NUMBER;
1802: l_capital_amount NUMBER;
1803: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
1804: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE := null;
1805: l_cap_yn VARCHAR2(3);
1806: l_mult_factor NUMBER;
1807: l_line_amount NUMBER;

Line 2195: okc_line_styles_b style

2191:
2192: CURSOR line_style_csr (p_line_id OKC_K_LINES_V.ID%TYPE) IS
2193: SELECT style.lty_code
2194: FROM okc_k_lines_b line,
2195: okc_line_styles_b style
2196: WHERE line.lse_id = style.id
2197: AND line.id = p_line_id;
2198:
2199: CURSOR pay_term_csr (p_id NUMBER,

Line 2239: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;

2235: AND trunc(nvl(start_date_active,sysdate)) <= trunc(sysdate)
2236: AND trunc(nvl(end_date_active,sysdate+1)) > trunc(sysdate);
2237:
2238: l_id1 VARCHAR2(30);
2239: l_line_type OKC_LINE_STYLES_B.LTY_CODE%TYPE;
2240:
2241: BEGIN
2242:
2243: x_return_status := OKL_API.G_RET_STS_SUCCESS;