APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_QUICK_QUOTES_B

Line 60: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

56: (SELECT std_rate_tmpl_ver_id FROM okl_fe_std_rt_tmp_vers WHERE adj_mat_version_id=p_version_id);
57:
58: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template
59: CURSOR srt_qq_csr(p_version_id IN NUMBER) IS
60: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b
61: WHERE rate_template_id in
62: (SELECT std_rate_tmpl_ver_id from okl_fe_std_rt_tmp_vers where adj_mat_version_id=p_version_id);
63:
64: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets

Line 72: SELECT max(expected_start_date) start_date FROM okl_quick_quotes_b

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