eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 86: FROM okl_fe_std_rt_tmp_v

82: ,creation_date
83: ,last_updated_by
84: ,last_update_date
85: ,last_update_login
86: FROM okl_fe_std_rt_tmp_v
87: WHERE std_rate_tmpl_id = p_srt_id;
88:
89: -- cursor to fetch the versions record
90:

Line 127: FROM okl_fe_std_rt_tmp_vers

123: ,creation_date
124: ,last_updated_by
125: ,last_update_date
126: ,last_update_login
127: FROM okl_fe_std_rt_tmp_vers
128: WHERE std_rate_tmpl_id = p_srt_id AND version_number = p_version_number;
129: l_api_name VARCHAR2(40) := 'get_std_rate_tmpl';
130: l_api_version NUMBER := 1.0;
131:

Line 469: FROM okl_fe_std_rt_tmp_vers

465: ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl) IS
466:
467: CURSOR get_version_number(p_srt_id IN NUMBER) IS
468: SELECT MAX(version_number)
469: FROM okl_fe_std_rt_tmp_vers
470: WHERE std_rate_tmpl_id = p_srt_id;
471: l_version_number VARCHAR2(24);
472: l_api_name VARCHAR2(40) := 'get_version';
473: l_api_version NUMBER := 1.0;

Line 582: FROM okl_fe_std_rt_tmp_v

578: AND p_eff_from BETWEEN val.datetime_valid AND NVL(val.datetime_invalid, TO_DATE('01-01-9999', 'dd-mm-yyyy'));
579:
580: CURSOR srt_unique_chk(p_name IN varchar2) IS
581: SELECT 'x'
582: FROM okl_fe_std_rt_tmp_v
583: WHERE template_name = UPPER(p_name);
584: BEGIN
585: l_return_status := okl_api.start_activity(l_api_name
586: ,g_pkg_name

Line 747: FROM okl_fe_std_rt_tmp_vers

743: CURSOR prev_ver_csr(l_srt_id IN NUMBER
744: ,l_version_number IN VARCHAR2) IS
745: SELECT effective_from_date
746: ,effective_to_date
747: FROM okl_fe_std_rt_tmp_vers
748: WHERE std_rate_tmpl_id = l_srt_id
749: AND version_number = l_version_number - 1;
750: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
751: SELECT max(effective_from_date)

Line 1186: FROM okl_fe_std_rt_tmp_vers

1182: ,version_number
1183: ,effective_from_date
1184: ,effective_to_date
1185: ,srt_rate
1186: FROM okl_fe_std_rt_tmp_vers
1187: WHERE std_rate_tmpl_ver_id = p_version_id;
1188:
1189: CURSOR ver_eff_to_csr(p_srt_id IN NUMBER
1190: ,p_version_number IN NUMBER) IS

Line 1193: FROM okl_fe_std_rt_tmp_vers

1189: CURSOR ver_eff_to_csr(p_srt_id IN NUMBER
1190: ,p_version_number IN NUMBER) IS
1191: SELECT std_rate_tmpl_ver_id
1192: ,effective_to_date
1193: FROM okl_fe_std_rt_tmp_vers
1194: WHERE std_rate_tmpl_id = p_srt_id AND version_number = p_version_number;
1195:
1196: CURSOR max_version_csr(p_srt_id IN NUMBER) IS
1197: SELECT MAX(version_number)

Line 1198: FROM okl_fe_std_rt_tmp_vers

1194: WHERE std_rate_tmpl_id = p_srt_id AND version_number = p_version_number;
1195:
1196: CURSOR max_version_csr(p_srt_id IN NUMBER) IS
1197: SELECT MAX(version_number)
1198: FROM okl_fe_std_rt_tmp_vers
1199: WHERE std_rate_tmpl_id = p_srt_id;
1200:
1201: CURSOR cal_rate_csr(index_id IN NUMBER
1202: ,effective_from IN DATE) IS

Line 1675: ,okl_fe_std_rt_tmp_vers srt

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:
1679: -- cursor to fetch the maximum start date of quick quotes referencing Standard Rate Template

Line 1684: ,okl_fe_std_rt_tmp_vers srt

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:
1688: -- cursor to fetch the maximum start date of lease quotes referencing Lease Rate Sets

Line 1712: FROM okl_fe_std_rt_tmp_vers

1708: CURSOR prev_ver_csr(p_srt_id IN NUMBER
1709: ,p_ver_number IN VARCHAR2) IS
1710: SELECT effective_from_date
1711: ,effective_to_date
1712: FROM okl_fe_std_rt_tmp_vers
1713: WHERE std_rate_tmpl_id = p_srt_id AND version_number = p_ver_number - 1;
1714:
1715: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
1716: SELECT max(effective_from_date)

Line 1834: FROM okl_fe_std_rt_tmp_vers

1830:
1831: CURSOR is_latest_version(p_srt_version_id IN NUMBER
1832: ,p_srt_id IN NUMBER) IS
1833: SELECT 'X'
1834: FROM okl_fe_std_rt_tmp_vers
1835: WHERE version_number = (SELECT MAX(version_number)
1836: FROM okl_fe_std_rt_tmp_vers
1837: WHERE std_rate_tmpl_id = p_srt_id)
1838: AND std_rate_tmpl_ver_id = p_srt_version_id;

Line 1836: FROM okl_fe_std_rt_tmp_vers

1832: ,p_srt_id IN NUMBER) IS
1833: SELECT 'X'
1834: FROM okl_fe_std_rt_tmp_vers
1835: WHERE version_number = (SELECT MAX(version_number)
1836: FROM okl_fe_std_rt_tmp_vers
1837: WHERE std_rate_tmpl_id = p_srt_id)
1838: AND std_rate_tmpl_ver_id = p_srt_version_id;
1839:
1840: CURSOR get_not_abn_versions(p_srt_version_id IN NUMBER

Line 1843: FROM okl_fe_std_rt_tmp_vers

1839:
1840: CURSOR get_not_abn_versions(p_srt_version_id IN NUMBER
1841: ,p_srt_id IN NUMBER) IS
1842: SELECT 'X'
1843: FROM okl_fe_std_rt_tmp_vers
1844: WHERE std_rate_tmpl_id = p_srt_id
1845: AND std_rate_tmpl_ver_id <> p_srt_version_id
1846: AND sts_code <> 'ABANDONED';
1847:

Line 1855: FROM okl_fe_std_rt_tmp_vers

1851: SELECT effective_from_date
1852: ,effective_to_date
1853: ,sts_code
1854: ,std_rate_tmpl_id
1855: FROM okl_fe_std_rt_tmp_vers
1856: WHERE std_rate_tmpl_ver_id = p_srt_version_id;
1857:
1858: -- cursor to calculate the LRS objects which are referncing this Standard Rate Template
1859: