DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKL_K_LINES

Line 1769: okl_k_lines_full_v line,

1765: style.lty_code,
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

Line 1783: FROM okl_k_lines_full_v line,

1779:
1780: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1781: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1782: SELECT stream.capitalize_yn
1783: FROM okl_k_lines_full_v line,
1784: okc_k_items_v item,
1785: okl_strmtyp_source_v stream
1786: WHERE line.id = p_line_id
1787: AND line.dnz_chr_id = p_chr_id

Line 1804: l_fee_type OKL_K_LINES.FEE_TYPE%TYPE := null;

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;
1808: l_initial_direct_cost okl_k_lines.initial_direct_cost%type := null;

Line 1808: l_initial_direct_cost okl_k_lines.initial_direct_cost%type := null;

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;
1808: l_initial_direct_cost okl_k_lines.initial_direct_cost%type := null;
1809: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1810:
1811: l_clev_rec clev_rec_type ;
1812: l_klev_rec klev_rec_type ;