[Home] [Help]
88: from okc_line_styles_b addon_lseb,
89: okc_k_lines_b addon_cleb,
90: okc_line_styles_b model_lseb,
91: okc_k_lines_b model_cleb,
92: okc_k_lines_tl clet,
93: okc_line_styles_b lseb,
94: okc_k_lines_b cleb
95: where
96: addon_cleb.cle_id = model_cleb.id
124: and model_cleb2.dnz_chr_id = cleb2.dnz_chr_id
125: and cleb2.chr_id = p_orig_chr_id --orig contract
126: and cleb2.dnz_chr_id = p_orig_chr_id);--orig contract
127:
128: l_asset_number okc_k_lines_tl.name%TYPE default NULL;
129:
130: --------------------------------------------------------------
131: --cursor to find any new add-ons added during rebook
132: --asset line had no add-ons but new one has been added
138: from okc_line_styles_b addon_lseb,
139: okc_k_lines_b addon_cleb,
140: okc_line_styles_b model_lseb,
141: okc_k_lines_b model_cleb,
142: okc_k_lines_tl clet,
143: okc_line_styles_b lseb,
144: okc_k_lines_b cleb
145: where
146: addon_cleb.cle_id = model_cleb.id
187: okc_line_styles_b addon_lseb,
188: okc_k_lines_b addon_cleb,
189: okc_line_styles_b model_lseb,
190: okc_k_lines_b model_cleb,
191: okc_k_lines_tl clet,
192: okc_line_styles_b lseb,
193: okc_k_lines_b cleb
194: where cim.cle_id = addon_cleb.id
195: and cim.dnz_chr_id = addon_cleb.dnz_chr_id
244: from okc_line_styles_b addon_lseb,
245: okc_k_lines_b addon_cleb,
246: okc_line_styles_b model_lseb,
247: okc_k_lines_b model_cleb,
248: okc_k_lines_tl clet,
249: okc_line_styles_b lseb,
250: okc_k_lines_b cleb
251: where
252: addon_cleb.cle_id = model_cleb.id
289: Cursor l_adj_modfn_csr (p_rbk_chr_id in NUMBER,
290: p_orig_chr_id in NUMBER) is
291: select clet.name
292: from okl_k_lines kle,
293: okc_k_lines_tl clet,
294: okc_k_lines_b cleb,
295: okc_line_styles_b lseb
296: where kle.id = cleb.id
297: and clet.id = cleb.id
962: cleb_asst.id asset_id -- added for subsidy pools enhancement
963: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
964: from okl_subsidies_b subb,
965: okl_k_lines kle_sub,
966: okc_k_lines_tl clet_sub,
967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,
969: okc_k_lines_tl clet_asst,
970: okc_k_lines_b cleb_asst,
965: okl_k_lines kle_sub,
966: okc_k_lines_tl clet_sub,
967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,
969: okc_k_lines_tl clet_asst,
970: okc_k_lines_b cleb_asst,
971: okc_line_styles_b lseb_asst
972: where subb.id = kle_sub.subsidy_id
973: --and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate