469: , okl_fee_line.fee_type
470: FROM okc_k_lines_b okc_fee_line ,
471: okl_k_lines okl_fee_line ,
472: okc_line_styles_b lse ,
473: okc_k_party_roles_b inv_line_role ,
474: okc_k_party_roles_b fee_line_role
475: WHERE inv_line_role.cle_id = p_investor_line_id
476: AND inv_line_role.dnz_chr_id = p_ia_id
477: AND inv_line_role.object1_id1 = fee_line_role.object1_id1
470: FROM okc_k_lines_b okc_fee_line ,
471: okl_k_lines okl_fee_line ,
472: okc_line_styles_b lse ,
473: okc_k_party_roles_b inv_line_role ,
474: okc_k_party_roles_b fee_line_role
475: WHERE inv_line_role.cle_id = p_investor_line_id
476: AND inv_line_role.dnz_chr_id = p_ia_id
477: AND inv_line_role.object1_id1 = fee_line_role.object1_id1
478: AND inv_line_role.rle_code = fee_line_role.rle_code