DBA Data[Home] [Help]

APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_STRM_TMPT_LINES_UV

Line 550: FROM OKL_STRM_TMPT_LINES_UV STL

546: (p_pdt_id number,
547: p_strm_purpose okl_strm_type_v.stream_type_purpose%type,
548: p_contract_start_date date) IS
549: SELECT PRIMARY_STY_ID
550: FROM OKL_STRM_TMPT_LINES_UV STL
551: WHERE --STL.PRIMARY_YN = 'Y' AND
552: STL.PDT_ID = p_pdt_id
553: AND (STL.START_DATE <= p_contract_start_date)
554: AND (STL.END_DATE >= p_contract_start_date OR STL.END_DATE IS NULL)

Line 562: FROM OKL_STRM_TMPT_LINES_UV STL

558: (p_pdt_id number,
559: p_strm_purpose okl_strm_type_v.stream_type_purpose%type,
560: p_contract_start_date date) IS
561: SELECT DEPENDENT_STY_ID
562: FROM OKL_STRM_TMPT_LINES_UV STL
563: WHERE --STL.PRIMARY_YN = 'Y' AND
564: STL.PDT_ID = p_pdt_id
565: AND (STL.START_DATE <= p_contract_start_date)
566: AND (STL.END_DATE >= p_contract_start_date OR STL.END_DATE IS NULL)