APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_FE_RATE_SET_VERSIONS

Line 1586: FROM okl_fe_rate_set_versions vers

1582: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1583: SELECT vers.rate_set_version_id id
1584: ,hdr.name name
1585: ,vers.version_number version_number
1586: FROM okl_fe_rate_set_versions vers
1587: ,okl_ls_rt_fctr_sets_v hdr
1588: WHERE vers.rate_set_id = hdr.id
1589: AND vers.std_rate_tmpl_ver_id = p_version_id
1590: AND vers.sts_code = 'ACTIVE';

Line 1694: FROM okl_fe_rate_set_versions

1690: CURSOR lrs_lq_csr(p_version_id IN NUMBER) IS
1691: SELECT MAX(expected_start_date) start_date
1692: FROM okl_lease_quotes_b
1693: WHERE rate_card_id IN(SELECT rate_set_version_id
1694: FROM okl_fe_rate_set_versions
1695: WHERE std_rate_tmpl_ver_id = p_version_id);
1696:
1697: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets
1698:

Line 1703: FROM okl_fe_rate_set_versions

1699: CURSOR lrs_qq_csr(p_version_id IN NUMBER) IS
1700: SELECT MAX(expected_start_date) start_date
1701: FROM okl_quick_quotes_b
1702: WHERE rate_card_id IN(SELECT rate_set_version_id
1703: FROM okl_fe_rate_set_versions
1704: WHERE std_rate_tmpl_ver_id = p_version_id);
1705:
1706: -- cursor to fetch the start date and the end of the previous version
1707:

Line 1864: FROM okl_fe_rate_set_versions vers

1860: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1861: SELECT vers.rate_set_version_id id
1862: ,hdr.name name
1863: ,vers.version_number version_number
1864: FROM okl_fe_rate_set_versions vers
1865: ,okl_ls_rt_fctr_sets_v hdr
1866: WHERE vers.rate_set_id = hdr.id
1867: AND vers.std_rate_tmpl_ver_id = p_version_id
1868: AND vers.sts_code = 'ACTIVE';