APPS.OKL_FE_EO_TERM_OPTIONS_PVT dependencies on OKL_QUICK_QUOTES_B

Line 548: SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE end_of_term_option_id=p_eot_version_id;

544:
545: -- cursor to calculate the maximum end date referenced in quote
546: -- the cursor to be modified as the quotes table is not finalized
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:

Line 554: SELECT max(expected_start_date) FROM okl_quick_quotes_b WHERE rate_card_id in

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