DBA Data[Home] [Help]

APPS.OKL_VERSION_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 72: FROM okc_subclass_top_line stl,

68: SELECT cle.id,
69: cle.dnz_chr_id,
70: cim.object1_id1,
71: cim.object1_id2
72: FROM okc_subclass_top_line stl,
73: okc_line_styles_b lse2,
74: okc_line_styles_b lse1,
75: okc_k_items_v cim,
76: okc_k_lines_v cle

Line 297: FROM okc_subclass_top_line stl,

293: SELECT cle.id,
294: cle.dnz_chr_id,
295: cim.object1_id1,
296: cim.object1_id2
297: FROM okc_subclass_top_line stl,
298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,

Line 314: FROM okc_subclass_top_line stl,

310: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
311: AND lse3.id = stl.lse_id
312: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
313: AND cle.cle_id in (SELECT cle.id
314: FROM okc_subclass_top_line stl,
315: okc_line_styles_b lse2,
316: okc_line_styles_b lse1,
317: okc_k_lines_b cle
318: WHERE cle.dnz_chr_id = p_dnz_chr_id