APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_LEASE_QUOTES_B

Line 551: SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE end_of_term_option_id=p_eot_version_id;

547: CURSOR qq_date_csr(p_eot_version_id IN NUMBER) IS
548: SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE end_of_term_option_id=p_eot_version_id;
549:
550: CURSOR lq_date_csr(p_eot_version_id IN NUMBER) IS
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);

Line 558: SELECT max(expected_start_date) FROM okl_lease_quotes_b WHERE rate_card_id in

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);
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