DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 341: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv

337: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
338: --Bug # 5050143 End
339: lrv.sts_code,
340: lrs.frq_code
341: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
342: where effective_start_date between lrv.effective_from_date and NVL(lrv.effective_to_date,effective_start_date+1)
343: and lrs.id=lrv.rate_set_id
344: and lrv.sts_code='ACTIVE'
345: and lrs.lrs_type_code='LEVEL'

Line 837: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv

833: nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
834: --Bug # 5050143 start
835: lrv.sts_code,
836: lrs.frq_code
837: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
838: where
839: effective_start_date between lrv.effective_from_date and NVL(lrv.effective_to_date,effective_start_date+1)
840: AND lrs.id=lrv.rate_set_id
841: and lrv.sts_code='ACTIVE'