[Home] [Help]
551: SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE end_of_term_option_id=p_eot_version_id;
552:
553: CURSOR lrs_qq_date_csr(p_eot_version_id IN NUMBER) IS
554: SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE rate_card_id in
555: (select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);
556:
557: CURSOR lrs_lq_date_csr(p_eot_version_id IN NUMBER) IS
558: SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE rate_card_id in
559: (select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);
555: (select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);
556:
557: CURSOR lrs_lq_date_csr(p_eot_version_id IN NUMBER) IS
558: SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE rate_card_id in
559: (select rate_set_version_id from OKL_FE_RATE_SET_VERSIONS where end_of_term_ver_id = p_eot_version_id);
560:
561: -- cursor to fetch the start date and the end of the previous version
562: CURSOR prev_ver_csr(p_eot_id IN NUMBER, p_ver_number IN VARCHAR2) IS
563: SELECT effective_from_date, effective_to_date FROM okl_fe_eo_term_vers where end_of_term_id= p_eot_id
1773:
1774: -- cursor to calculate the LRS objects which are referncing this adjustment matrix
1775: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1776: SELECT vers.RATE_SET_VERSION_ID ID,hdr.name NAME,vers.version_number VERSION_NUMBER
1777: FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr
1778: WHERE vers.rate_set_id = hdr.id AND vers.end_of_term_ver_id=p_version_id
1779: AND vers.STS_CODE='ACTIVE';
1780:
1781: l_version_id NUMBER :=p_version_id;