DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_QUICK_QUOTES_B

Line 1683: FROM okl_quick_quotes_b qq

1679: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template
1680:
1681: CURSOR srt_qq_csr(p_version_id IN NUMBER) IS
1682: SELECT MAX(qq.expected_start_date) start_date
1683: FROM okl_quick_quotes_b qq
1684: ,okl_fe_std_rt_tmp_vers srt
1685: WHERE srt.std_rate_tmpl_ver_id = p_version_id
1686: AND qq.rate_template_id = srt.std_rate_tmpl_ver_id;
1687:

Line 1701: FROM okl_quick_quotes_b

1697: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets
1698:
1699: CURSOR lrs_qq_csr(p_version_id IN NUMBER) IS
1700: SELECT MAX(expected_start_date) start_date
1701: FROM okl_quick_quotes_b
1702: WHERE rate_card_id IN(SELECT rate_set_version_id
1703: FROM okl_fe_rate_set_versions
1704: WHERE std_rate_tmpl_ver_id = p_version_id);
1705: