DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKL_K_HEADERS

Line 100: OKL_K_HEADERS khr

96: FROM okl_strm_tmpt_full_uv
97: WHERE STY_PURPOSE = 'SERVICE_PAYMENT'
98: and exists (SELECT 1
99: FROM OKC_K_HEADERS_B chr,
100: OKL_K_HEADERS khr
101: WHERE chr.id = khr.id
102: AND khr.pdt_id = okl_strm_tmpt_full_uv.PDT_ID
103: AND trunc(chr.start_date) BETWEEN trunc(okl_strm_tmpt_full_uv.START_DATE) AND nvl(trunc(okl_strm_tmpt_full_uv.END_DATE),chr.start_date+1)
104: AND chr.id = p_chr_id)