DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_LINE_STYLES_V

Line 1769: OKC_LINE_STYLES_V OLSV,

1765: CURSOR k_lines_csr(p_khr_id IN NUMBER) IS
1766: SELECT OKLV.id kle_id,
1767: OKLV.name asset_name
1768: FROM OKC_K_LINES_V OKLV,
1769: OKC_LINE_STYLES_V OLSV,
1770: OKC_K_HEADERS_V KHR
1771: WHERE OKLV.chr_id = p_khr_id
1772: AND OKLV.lse_id = OLSV.id
1773: AND OLSV.lty_code = 'FREE_FORM1'

Line 6356: okc_line_styles_v olsv,

6352: CURSOR k_asst_fee_srvc_lns_csr(p_khr_id IN NUMBER) IS
6353: SELECT oklv.id kle_id,
6354: oklv.NAME asset_name
6355: FROM okc_k_lines_v oklv,
6356: okc_line_styles_v olsv,
6357: okc_k_headers_v khr
6358: WHERE oklv.chr_id = p_khr_id AND oklv.lse_id = olsv.id AND
6359: olsv.lty_code IN
6360: ('FREE_FORM1', 'FEE', 'SOLD_SERVICE') AND