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_LEASE_RATE_SETS_PVT dependencies on OKL_FE_RATE_SET_VERSIONS

Line 516: ,okl_fe_rate_set_versions lrv

512:
513: CURSOR lrs_lq_csr IS
514: SELECT max(qte.expected_start_date) start_date
515: FROM okl_lease_quotes_b qte
516: ,okl_fe_rate_set_versions lrv
517: WHERE qte.rate_card_id = lrv.rate_set_version_id
518: AND lrv.rate_set_version_id = p_lrv_id;
519:
520: -- cursor to fetch the maximum start date of quick quotes referencing Lease Rate Sets

Line 525: ,okl_fe_rate_set_versions lrv

521:
522: CURSOR lrs_qq_csr IS
523: SELECT max(qte.expected_start_date) start_date
524: FROM okl_quick_quotes_b qte
525: ,okl_fe_rate_set_versions lrv
526: WHERE qte.rate_card_id = lrv.rate_set_version_id
527: AND lrv.rate_set_version_id = p_lrv_id;
528:
529: --cursor to fetch previous version effective_from and to dates

Line 534: FROM okl_fe_rate_set_versions

530:
531: CURSOR get_prev_ver_eff_to IS
532: SELECT effective_from_date
533: ,effective_to_date
534: FROM okl_fe_rate_set_versions
535: WHERE rate_set_version_id = p_lrv_id;
536:
537: --cursor to fetch maximum of the start date of the eligibility criteria attached to
538: --lease rate set.

Line 812: FROM okl_fe_rate_set_versions_v

808: ,attribute12
809: ,attribute13
810: ,attribute14
811: ,attribute15
812: FROM okl_fe_rate_set_versions_v
813: WHERE rate_set_version_id = p_id;
814: l_lrvv_pk lrvv_pk_csr%ROWTYPE;
815: l_lrvv_rec okl_lrvv_rec;
816: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_lease_rate_sets_pvt.get_lrvv_rec';

Line 901: FROM okl_fe_rate_set_versions

897:
898: CURSOR get_prev_ver_id(p_lrt_id IN number
899: ,p_version_number IN varchar2) IS
900: SELECT rate_set_version_id
901: FROM okl_fe_rate_set_versions
902: WHERE rate_set_id = p_lrt_id AND version_number = p_version_number;
903:
904: CURSOR get_eot_version(p_eot_id number
905: ,p_eff_from IN date) IS

Line 1111: ,p_rate_set_version_id IN okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS

1107: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1108: ,x_return_status OUT NOCOPY varchar2
1109: ,x_msg_count OUT NOCOPY number
1110: ,x_msg_data OUT NOCOPY varchar2
1111: ,p_rate_set_version_id IN okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS
1112:
1113: CURSOR get_prev_ver_id(p_lrt_id IN number
1114: ,p_version_number IN varchar2) IS
1115: SELECT rate_set_version_id

Line 1116: FROM okl_fe_rate_set_versions

1112:
1113: CURSOR get_prev_ver_id(p_lrt_id IN number
1114: ,p_version_number IN varchar2) IS
1115: SELECT rate_set_version_id
1116: FROM okl_fe_rate_set_versions
1117: WHERE rate_set_id = p_lrt_id AND version_number = p_version_number;
1118:
1119: CURSOR get_rate_set_id(p_lrv_id IN number) IS
1120: SELECT rate_set_id

Line 1122: FROM okl_fe_rate_set_versions

1118:
1119: CURSOR get_rate_set_id(p_lrv_id IN number) IS
1120: SELECT rate_set_id
1121: ,effective_from_date
1122: FROM okl_fe_rate_set_versions
1123: WHERE rate_set_version_id = p_rate_set_version_id;
1124:
1125: CURSOR get_ver_no(p_lrv_id number) IS
1126: SELECT version_number

Line 1127: FROM okl_fe_rate_set_versions

1123: WHERE rate_set_version_id = p_rate_set_version_id;
1124:
1125: CURSOR get_ver_no(p_lrv_id number) IS
1126: SELECT version_number
1127: FROM okl_fe_rate_set_versions
1128: WHERE rate_set_version_id = p_lrv_id;
1129: l_ver_no varchar2(30);
1130: lp_lrvv_rec okl_lrvv_rec;
1131: x_lrvv_rec okl_lrvv_rec;

Line 1348: ,p_rate_set_version_id IN okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS

1344: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1345: ,x_return_status OUT NOCOPY varchar2
1346: ,x_msg_count OUT NOCOPY number
1347: ,x_msg_data OUT NOCOPY varchar2
1348: ,p_rate_set_version_id IN okl_fe_rate_set_versions.rate_set_version_id%TYPE) IS
1349: lp_lrvv_rec okl_lrvv_rec;
1350: l_prev_lrvv_rec okl_lrvv_rec;
1351: x_lrvv_rec okl_lrvv_rec;
1352: lp_lrtv_rec lrtv_rec_type;

Line 1365: FROM okl_fe_rate_set_versions

1361: l_lrs_rate number;
1362:
1363: CURSOR get_rate_set_id(p_lrv_id IN number) IS
1364: SELECT rate_set_id
1365: FROM okl_fe_rate_set_versions
1366: WHERE rate_set_version_id = p_lrv_id;
1367:
1368: CURSOR get_prev_ver_id(p_lrt_id IN number
1369: ,p_version_number IN varchar2) IS

Line 1371: FROM okl_fe_rate_set_versions

1367:
1368: CURSOR get_prev_ver_id(p_lrt_id IN number
1369: ,p_version_number IN varchar2) IS
1370: SELECT rate_set_version_id
1371: FROM okl_fe_rate_set_versions
1372: WHERE rate_set_id = p_lrt_id AND version_number = p_version_number;
1373:
1374: CURSOR get_interest_rate(p_lrv_id IN number) IS
1375: SELECT nvl(lrs_rate,standard_rate) interest_rate

Line 1376: FROM okl_fe_rate_set_versions lrsv

1372: WHERE rate_set_id = p_lrt_id AND version_number = p_version_number;
1373:
1374: CURSOR get_interest_rate(p_lrv_id IN number) IS
1375: SELECT nvl(lrs_rate,standard_rate) interest_rate
1376: FROM okl_fe_rate_set_versions lrsv
1377: WHERE lrsv.rate_set_version_id = p_lrv_id;
1378: l_ech_rec okl_ech_rec;
1379: l_ecl_tbl okl_ecl_tbl;
1380: l_ecv_tbl okl_ecv_tbl;

Line 2694: FROM okl_fe_rate_set_versions

2690:
2691: CURSOR is_latest_version(p_rate_set_version_id IN number
2692: ,p_rate_set_id IN number) IS
2693: SELECT 'X'
2694: FROM okl_fe_rate_set_versions
2695: WHERE version_number = (SELECT max(to_number(version_number))
2696: FROM okl_fe_rate_set_versions
2697: WHERE rate_set_id = p_rate_set_id)
2698: AND rate_set_version_id = p_rate_set_version_id;

Line 2696: FROM okl_fe_rate_set_versions

2692: ,p_rate_set_id IN number) IS
2693: SELECT 'X'
2694: FROM okl_fe_rate_set_versions
2695: WHERE version_number = (SELECT max(to_number(version_number))
2696: FROM okl_fe_rate_set_versions
2697: WHERE rate_set_id = p_rate_set_id)
2698: AND rate_set_version_id = p_rate_set_version_id;
2699:
2700: CURSOR get_not_abn_versions(p_rate_set_version_id IN number

Line 2703: FROM okl_fe_rate_set_versions

2699:
2700: CURSOR get_not_abn_versions(p_rate_set_version_id IN number
2701: ,p_rate_set_id IN number) IS
2702: SELECT 'X'
2703: FROM okl_fe_rate_set_versions
2704: WHERE rate_set_id = p_rate_set_id
2705: AND rate_set_version_id <> p_rate_set_version_id
2706: AND sts_code <> 'ABANDONED';
2707: lp_lrvv_rec okl_lrvv_rec;