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_VAR_INT_REAMORT_PVT dependencies on OKC_RULES_B

Line 60: from okc_rules_b sll,

56: sll.rule_information8 stub_amount,
57: sll.rule_information10 advance_or_arrears,
58: sll.rule_information13 rate,
59: rgp.cle_id cle_id
60: from okc_rules_b sll,
61: okc_rules_b slh,
62: okl_strm_type_v styp,
63: okc_rule_groups_b rgp
64: where to_number(sll.object2_id1) = slh.id

Line 61: okc_rules_b slh,

57: sll.rule_information10 advance_or_arrears,
58: sll.rule_information13 rate,
59: rgp.cle_id cle_id
60: from okc_rules_b sll,
61: okc_rules_b slh,
62: okl_strm_type_v styp,
63: okc_rule_groups_b rgp
64: where to_number(sll.object2_id1) = slh.id
65: and sll.rule_information_category = 'LASLL'

Line 302: from okc_rules_b sll,

298: CURSOR l_stub_csr(cp_kle_id IN NUMBER, cp_start_date IN DATE) IS
299: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
300: sll.rule_information7 stub_days,
301: sll.rule_information8 stub_amount
302: from okc_rules_b sll,
303: okc_rules_b slh,
304: okl_strm_type_v styp,
305: okc_rule_groups_b rgp
306: where to_number(sll.object2_id1) = slh.id

Line 303: okc_rules_b slh,

299: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
300: sll.rule_information7 stub_days,
301: sll.rule_information8 stub_amount
302: from okc_rules_b sll,
303: okc_rules_b slh,
304: okl_strm_type_v styp,
305: okc_rule_groups_b rgp
306: where to_number(sll.object2_id1) = slh.id
307: and sll.rule_information_category = 'LASLL'

Line 786: from okc_rules_b sll_rulb,

782: slh_rulb.jtot_object2_code time_value,
783: slh_rulb.object1_id1 sty_id,
784: slh_rulb.rule_information1 billing_schedule_type,
785: slh_rulb.rule_information2 rate_type
786: from okc_rules_b sll_rulb,
787: okc_rules_b slh_rulb,
788: okl_strm_type_b styb,
789: okc_rule_groups_b rgpb
790: where sll_rulb.rgp_id = rgpb.id

Line 787: okc_rules_b slh_rulb,

783: slh_rulb.object1_id1 sty_id,
784: slh_rulb.rule_information1 billing_schedule_type,
785: slh_rulb.rule_information2 rate_type
786: from okc_rules_b sll_rulb,
787: okc_rules_b slh_rulb,
788: okl_strm_type_b styb,
789: okc_rule_groups_b rgpb
790: where sll_rulb.rgp_id = rgpb.id
791: and sll_rulb.rule_information_category = 'LASLL'

Line 820: okc_rules_b rul1,

816: CURSOR c_freq_cur(p_contract_id NUMBER, p_cle_id IN NUMBER)
817: IS
818: SELECT rul2.object1_id1
819: FROM okc_rule_groups_b rgp,
820: okc_rules_b rul1,
821: okc_rules_b rul2,
822: okl_strm_type_b sty
823: WHERE rul2.dnz_chr_id = p_contract_id
824: AND rul2.rule_information_category = 'LASLL'

Line 821: okc_rules_b rul2,

817: IS
818: SELECT rul2.object1_id1
819: FROM okc_rule_groups_b rgp,
820: okc_rules_b rul1,
821: okc_rules_b rul2,
822: okl_strm_type_b sty
823: WHERE rul2.dnz_chr_id = p_contract_id
824: AND rul2.rule_information_category = 'LASLL'
825: AND rul2.rgp_id = rgp.id

Line 848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;

844: l_period_cntr NUMBER := 0;
845: l_prior_level_date_start DATE;
846: l_level_date_start DATE;
847: l_sequence NUMBER := 0;
848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
849: l_stream_level_header okc_rules_b.jtot_object2_code%type;
850: l_tuoms_per_period okc_rules_b.rule_information4%type;
851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
852: l_structure okc_rules_b.rule_information5%type;

Line 849: l_stream_level_header okc_rules_b.jtot_object2_code%type;

845: l_prior_level_date_start DATE;
846: l_level_date_start DATE;
847: l_sequence NUMBER := 0;
848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
849: l_stream_level_header okc_rules_b.jtot_object2_code%type;
850: l_tuoms_per_period okc_rules_b.rule_information4%type;
851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
852: l_structure okc_rules_b.rule_information5%type;
853:

Line 850: l_tuoms_per_period okc_rules_b.rule_information4%type;

846: l_level_date_start DATE;
847: l_sequence NUMBER := 0;
848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
849: l_stream_level_header okc_rules_b.jtot_object2_code%type;
850: l_tuoms_per_period okc_rules_b.rule_information4%type;
851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
852: l_structure okc_rules_b.rule_information5%type;
853:
854: l_stub_start_date DATE;

Line 851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;

847: l_sequence NUMBER := 0;
848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
849: l_stream_level_header okc_rules_b.jtot_object2_code%type;
850: l_tuoms_per_period okc_rules_b.rule_information4%type;
851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
852: l_structure okc_rules_b.rule_information5%type;
853:
854: l_stub_start_date DATE;
855: l_stub_days NUMBER;

Line 852: l_structure okc_rules_b.rule_information5%type;

848: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
849: l_stream_level_header okc_rules_b.jtot_object2_code%type;
850: l_tuoms_per_period okc_rules_b.rule_information4%type;
851: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
852: l_structure okc_rules_b.rule_information5%type;
853:
854: l_stub_start_date DATE;
855: l_stub_days NUMBER;
856: l_stub_amount NUMBER;

Line 1500: l_frequency okc_rules_b.object1_id1%type;

1496: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
1497: l_msg_index_out NUMBER;
1498: l_term_duration NUMBER;
1499: l_tot_principal_amount NUMBER := 0;
1500: l_frequency okc_rules_b.object1_id1%type;
1501: l_csm_line_details_ctr NUMBER;
1502: l_first_row NUMBER;
1503: l_loan_levels_cntr NUMBER;
1504: l_loan_levels_date_start DATE;

Line 1610: okc_rules_b rul1,

1606: -- Payment Levels of Rent/Principal Payment/Loan Payment of Assets only
1607: CURSOR c_freq_cur(p_contract_id NUMBER) IS
1608: SELECT rul2.object1_id1
1609: FROM okc_rule_groups_b rgp,
1610: okc_rules_b rul1,
1611: okc_rules_b rul2,
1612: okl_strm_type_b sty
1613: WHERE rul2.dnz_chr_id = p_contract_id
1614: AND rul2.rule_information_category = 'LASLL'

Line 1611: okc_rules_b rul2,

1607: CURSOR c_freq_cur(p_contract_id NUMBER) IS
1608: SELECT rul2.object1_id1
1609: FROM okc_rule_groups_b rgp,
1610: okc_rules_b rul1,
1611: okc_rules_b rul2,
1612: okl_strm_type_b sty
1613: WHERE rul2.dnz_chr_id = p_contract_id
1614: AND rul2.rule_information_category = 'LASLL'
1615: AND rul2.rgp_id = rgp.id