DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_LEASE_QUOTES_B

Line 1674: FROM okl_lease_quotes_b lq

1670: -- cursor to fetch the maximum start date of lease quotes referencing Standard Rate Template
1671:
1672: CURSOR srt_lq_csr(p_version_id IN NUMBER) IS
1673: SELECT MAX(lq.expected_start_date) start_date
1674: FROM okl_lease_quotes_b lq
1675: ,okl_fe_std_rt_tmp_vers srt
1676: WHERE srt.std_rate_tmpl_ver_id = p_version_id
1677: AND lq.rate_template_id = srt.std_rate_tmpl_ver_id;
1678:

Line 1692: FROM okl_lease_quotes_b

1688: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets
1689:
1690: CURSOR lrs_lq_csr(p_version_id IN NUMBER) IS
1691: SELECT MAX(expected_start_date) start_date
1692: FROM okl_lease_quotes_b
1693: WHERE rate_card_id IN(SELECT rate_set_version_id
1694: FROM okl_fe_rate_set_versions
1695: WHERE std_rate_tmpl_ver_id = p_version_id);
1696: