APPS.OKE_DEFAULTING_PKG dependencies on OKC_K_LINES_B

Line 1223: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)

1219: where h.id = p_id
1220: and l.header_id = p_id
1221: and h.id = k.k_header_id
1222: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1223: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
1224: and exists (select 'x' from okc_assents a
1225: where a.opn_code = 'CREATE_DELV'
1226: and a.sts_code = l.status_code
1227: and a.scs_code = 'PROJECT'