DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKL_K_LINES

Line 1714: okl_k_lines_full_v line,

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

Line 1728: FROM okl_k_lines_full_v line,

1724:
1725: CURSOR strm_cap_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1726: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1727: SELECT stream.capitalize_yn
1728: FROM okl_k_lines_full_v line,
1729: okc_k_items_v item,
1730: okl_strmtyp_source_v stream
1731: WHERE line.id = p_line_id
1732: AND line.dnz_chr_id = p_chr_id

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

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

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

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;
1753: l_initial_direct_cost okl_k_lines.initial_direct_cost%type := null;
1754: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1755:
1756: l_clev_rec clev_rec_type ;
1757: l_klev_rec klev_rec_type ;