APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_LEASE_QUOTES_B

Line 54: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

50: i NUMBER;
51:
52: -- cursor to fetch the maximum start date of lease quotes referencing Standard Rate Template
53: CURSOR srt_lq_csr(p_version_id IN NUMBER) IS
54: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b
55: WHERE rate_template_id IN
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

Line 66: SELECT max(expected_start_date) start_date FROM okl_lease_quotes_b

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