APPS.OKL_EC_UPTAKE_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 566: okl_fe_std_rt_tmp_v srt,

562: srv.max_adj_rate,
563: srv.min_adj_rate
564: ---
565: from
566: okl_fe_std_rt_tmp_v srt,
567: okl_fe_std_rt_tmp_vers srv
568: where
569: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
570: AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id

Line 567: okl_fe_std_rt_tmp_vers srv

563: srv.min_adj_rate
564: ---
565: from
566: okl_fe_std_rt_tmp_v srt,
567: okl_fe_std_rt_tmp_vers srv
568: where
569: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
570: AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
571: AND srv.sts_code='ACTIVE'

Line 598: okl_fe_std_rt_tmp_v srt,

594: srv.max_adj_rate,
595: srv.min_adj_rate
596: ---
597: from
598: okl_fe_std_rt_tmp_v srt,
599: okl_fe_std_rt_tmp_vers srv,
600: okl_index_values oiv
601: where
602: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)

Line 599: okl_fe_std_rt_tmp_vers srv,

595: srv.min_adj_rate
596: ---
597: from
598: okl_fe_std_rt_tmp_v srt,
599: okl_fe_std_rt_tmp_vers srv,
600: okl_index_values oiv
601: where
602: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
603: and srt.std_rate_tmpl_id=srv.std_rate_tmpl_id

Line 1036: okl_fe_std_rt_tmp_v srt,

1032: srv.max_adj_rate,
1033: srv.min_adj_rate
1034: ---
1035: from
1036: okl_fe_std_rt_tmp_v srt,
1037: okl_fe_std_rt_tmp_vers srv
1038: where
1039: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
1040: AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id

Line 1037: okl_fe_std_rt_tmp_vers srv

1033: srv.min_adj_rate
1034: ---
1035: from
1036: okl_fe_std_rt_tmp_v srt,
1037: okl_fe_std_rt_tmp_vers srv
1038: where
1039: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
1040: AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
1041: AND srv.sts_code='ACTIVE'

Line 1068: okl_fe_std_rt_tmp_v srt,

1064: srv.max_adj_rate,
1065: srv.min_adj_rate
1066: ---
1067: from
1068: okl_fe_std_rt_tmp_v srt,
1069: okl_fe_std_rt_tmp_vers srv,
1070: okl_index_values oiv
1071: where
1072: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)

Line 1069: okl_fe_std_rt_tmp_vers srv,

1065: srv.min_adj_rate
1066: ---
1067: from
1068: okl_fe_std_rt_tmp_v srt,
1069: okl_fe_std_rt_tmp_vers srv,
1070: okl_index_values oiv
1071: where
1072: effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
1073: and srt.std_rate_tmpl_id=srv.std_rate_tmpl_id