DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_LINE_STYLES_B

Line 1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts

1615:
1616: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1617: SELECT cle.ID,
1618: cle.price_negotiated amount
1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1620: WHERE cle.lse_id = ls.ID
1621: AND ls.lty_code = ltycode
1622: AND cle.dnz_chr_id = chrid
1623: AND sts.code = cle.sts_code

Line 2335: okc_line_styles_b fa_lse,

2331: fab.current_units current_units
2332: FROM okl_txl_cntrct_lns tcl,
2333: okc_k_lines_b fin_ast_cle,
2334: okc_k_lines_b fa_cle,
2335: okc_line_styles_b fa_lse,
2336: okc_k_items cim,
2337: fa_additions_b fab
2338: WHERE tcl.tcn_id = p_source_trx_id
2339: AND tcl.before_transfer_yn = 'N'

Line 2358: okc_line_styles_b fin_ast_lse,

2354: fab.current_units current_units
2355: FROM okc_k_lines_b fin_ast_cle,
2356: okc_k_lines_b fa_cle,
2357: okc_k_headers_b CHR,
2358: okc_line_styles_b fin_ast_lse,
2359: okc_line_styles_b fa_lse,
2360: okc_k_items cim,
2361: fa_additions_b fab
2362: WHERE CHR.ID = p_orig_chr_id

Line 2359: okc_line_styles_b fa_lse,

2355: FROM okc_k_lines_b fin_ast_cle,
2356: okc_k_lines_b fa_cle,
2357: okc_k_headers_b CHR,
2358: okc_line_styles_b fin_ast_lse,
2359: okc_line_styles_b fa_lse,
2360: okc_k_items cim,
2361: fa_additions_b fab
2362: WHERE CHR.ID = p_orig_chr_id
2363: AND fin_ast_cle.chr_id = CHR.ID

Line 2440: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse

2436:
2437: --Bug# 4631549
2438: CURSOR off_lease_ast_csr (p_orig_chr_id IN NUMBER) IS
2439: SELECT fin_ast_cle.ID
2440: FROM okc_k_lines_b fin_ast_cle, okc_line_styles_b fin_ast_lse
2441: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2442: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id
2443: AND fin_ast_cle.lse_id = fin_ast_lse.ID
2444: AND fin_ast_lse.lty_code = 'FREE_FORM1'

Line 2453: okc_line_styles_b fin_ast_lse,

2449: SELECT tas.ID,
2450: tas.tsu_code,
2451: txl.hold_period_days
2452: FROM okc_k_lines_b fin_ast_cle,
2453: okc_line_styles_b fin_ast_lse,
2454: okl_trx_assets tas,
2455: okl_txl_assets_b txl
2456: WHERE fin_ast_cle.chr_id = p_orig_chr_id
2457: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id