APPS.OKE_DEFAULTING_PKG dependencies on OKC_K_LINES_B

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

1197: where h.id = p_id
1198: and l.header_id = p_id
1199: and h.id = k.k_header_id
1200: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')
1201: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
1202: and exists (select 'x' from okc_assents a
1203: where a.opn_code = 'CREATE_DELV'
1204: and a.sts_code = l.status_code
1205: and a.scs_code = 'PROJECT'