DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_STRM_TMPT_LINES_UV

Line 466: FROM okl_strm_tmpt_lines_uv stl

462:
463: CURSOR l_rep_strm_csr (rep_pdt_id number,styid number,primary_sty_purpose
464: varchar2,contract_start_date date ) IS
465: SELECT primary_sty_id
466: FROM okl_strm_tmpt_lines_uv stl
467: WHERE stl.primary_yn = 'Y'
468: AND stl.pdt_id = rep_pdt_id
469: AND (stl.start_date <= contract_start_date)
470: AND (stl.end_date >= contract_start_date OR stl.end_date IS NULL)