DBA Data[Home] [Help]

APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_SUBCLASS_TOP_LINE

Line 1198: okc_subclass_top_line stl

1194: CURSOR c_lines IS
1195: SELECT cle.id
1196: FROM okc_k_lines_b cle,
1197: okc_line_styles_b lse,
1198: okc_subclass_top_line stl
1199: WHERE chr_id = p_source_chr_id
1200: AND cle.lse_id= lse.id
1201: AND stl.scs_code = 'LEASE'
1202: AND lse.id = stl.lse_id

Line 1210: okc_subclass_top_line stl

1206: CURSOR new_c_lines(p_dest_chr_id NUMBER) IS
1207: SELECT cle.id
1208: FROM okc_k_lines_b cle,
1209: okc_line_styles_b lse,
1210: okc_subclass_top_line stl
1211: WHERE chr_id = p_dest_chr_id
1212: AND cle.lse_id= lse.id
1213: AND stl.scs_code = 'LEASE'
1214: AND lse.id = stl.lse_id