APPS.OKL_LRF_GENERATE_PVT dependencies on OKL_FE_RATE_SET_VERSIONS

Line 167: ,p_rate_set_version_id okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS

163: ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
164: ,x_return_status OUT NOCOPY varchar2
165: ,x_msg_count OUT NOCOPY number
166: ,x_msg_data OUT NOCOPY varchar2
167: ,p_rate_set_version_id okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS
168:
169: CURSOR c_rate_set(csr_rate_set_version_id IN number) IS
170: SELECT decode(b.arrears_yn, 'Y', 1, 0) arrears
171: ,decode(a.frq_code, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, 0) frequency

Line 182: ,okl_fe_rate_set_versions b

178: ,nvl(b.residual_tolerance, 0) residual_tolerance
179: ,b.rate_set_id
180: ,b.standard_rate
181: FROM okl_ls_rt_fctr_sets_v a
182: ,okl_fe_rate_set_versions b
183: WHERE a.id = b.rate_set_id
184: AND b.rate_set_version_id = csr_rate_set_version_id;
185: c_rate_set_rec c_rate_set%ROWTYPE;
186:

Line 752: FROM okl_fe_rate_set_versions

748:
749: CURSOR get_lrs_versions(p_start_date IN date
750: ,p_end_date IN date) IS
751: SELECT rate_set_version_id
752: FROM okl_fe_rate_set_versions
753: WHERE effective_from_date BETWEEN p_start_date AND nvl(p_end_date, to_date('01-01-9999', 'dd-mm-yyyy'))
754: AND sts_code = 'NEW' AND rate_set_id NOT IN(SELECT id
755: FROM okl_ls_rt_fctr_sets_v WHERE lrs_type_code = 'MANUAL');
756: