DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_FE_STD_RT_TMP_ALL_B

Line 1210: FROM okl_fe_std_rt_tmp_all_b

1206: AND effective_from <= NVL(datetime_invalid, TO_DATE('01-01-9999', 'dd-mm-yyyy'));
1207:
1208: CURSOR index_id_csr(p_srt_id IN NUMBER) IS
1209: SELECT index_id
1210: FROM okl_fe_std_rt_tmp_all_b
1211: WHERE std_rate_tmpl_id = p_srt_id;
1212: l_srt_id NUMBER;
1213: l_srt_ver_id NUMBER;
1214: l_index_id NUMBER;

Line 1470: FROM okl_fe_std_rt_tmp_all_b

1466: ,p_srt_id IN NUMBER) AS
1467:
1468: CURSOR default_yn_csr IS
1469: SELECT std_rate_tmpl_id
1470: FROM okl_fe_std_rt_tmp_all_b
1471: WHERE default_yn = 'Y';
1472: l_srtv_rec okl_srtv_rec;
1473: x_srtv_rec okl_srtv_rec;
1474: l_srt_id NUMBER;