[Home] [Help]
64: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets
65: CURSOR lrs_lq_csr(p_version_id IN NUMBER) IS
66: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
67: WHERE rate_card_id IN
68: (SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);
69:
70: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets
71: CURSOR lrs_qq_csr(p_version_id IN NUMBER) IS
72: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
70: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets
71: CURSOR lrs_qq_csr(p_version_id IN NUMBER) IS
72: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
73: WHERE rate_card_id IN
74: (SELECT rate_set_version_id FROM okl_fe_rate_set_versions WHERE adj_mat_version_id=p_version_id);
75:
76: -- cursor to fetch the start date and the end of the previous version
77: CURSOR prev_ver_csr(p_adj_mat_id IN NUMBER, p_ver_number IN VARCHAR2) IS
78: SELECT effective_from_date, effective_to_date FROM okl_fe_adj_mat_versions where adj_mat_id= p_adj_mat_id
1877: -- cursor to calculate the LRS objects which are referncing this adjustment matrix
1878:
1879: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1880: SELECT vers.RATE_SET_VERSION_ID ID,hdr.name NAME,vers.version_number VERSION_NUMBER
1881: FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr
1882: WHERE vers.rate_set_id = hdr.id AND vers.adj_mat_version_id=p_version_id
1883: AND vers.STS_CODE='ACTIVE';
1884:
1885: -- cursor to calculate the LRS invalid for the invalid SRTs
1886: CURSOR lrs_srt_invalids_csr(p_version_id IN NUMBER) IS
1887: SELECT vers.rate_set_version_id id
1888: ,hdr.name name
1889: ,vers.version_number version_number
1890: FROM okl_fe_rate_set_versions vers
1891: ,okl_ls_rt_fctr_sets_v hdr
1892: WHERE vers.rate_set_id = hdr.id
1893: AND vers.std_rate_tmpl_ver_id = p_version_id
1894: AND vers.sts_code = 'ACTIVE';