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

Line 120: from okc_rules_b sll,

116: sll.rule_information8 stub_amount,
117: sll.rule_information10 advance_or_arrears,
118: sll.rule_information13 rate,
119: rgp.cle_id cle_id
120: from okc_rules_b sll,
121: okc_rules_b slh,
122: okl_strm_type_v styp,
123: okc_rule_groups_b rgp
124: where to_number(sll.object2_id1) = slh.id

Line 121: okc_rules_b slh,

117: sll.rule_information10 advance_or_arrears,
118: sll.rule_information13 rate,
119: rgp.cle_id cle_id
120: from okc_rules_b sll,
121: okc_rules_b slh,
122: okl_strm_type_v styp,
123: okc_rule_groups_b rgp
124: where to_number(sll.object2_id1) = slh.id
125: and sll.rule_information_category = 'LASLL'

Line 161: from okc_rules_b sll,

157: CURSOR l_stub_csr(cp_kle_id IN NUMBER, cp_start_date IN DATE) IS
158: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
159: sll.rule_information7 stub_days,
160: sll.rule_information8 stub_amount
161: from okc_rules_b sll,
162: okc_rules_b slh,
163: okl_strm_type_v styp,
164: okc_rule_groups_b rgp
165: where to_number(sll.object2_id1) = slh.id

Line 162: okc_rules_b slh,

158: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
159: sll.rule_information7 stub_days,
160: sll.rule_information8 stub_amount
161: from okc_rules_b sll,
162: okc_rules_b slh,
163: okl_strm_type_v styp,
164: okc_rule_groups_b rgp
165: where to_number(sll.object2_id1) = slh.id
166: and sll.rule_information_category = 'LASLL'

Line 2305: okc_rules_b rules,

2301: chr.start_date start_date
2302: FROM okc_k_headers_b chr,
2303: okl_k_headers khr,
2304: okc_statuses_b khs,
2305: okc_rules_b rules,
2306: okc_rule_groups_b rgp
2307: WHERE CHR.CONTRACT_NUMBER = NVL(l_contract_number,CHR.CONTRACT_NUMBER)
2308: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING',
2309: 'LEASEST','LEASEOP')

Line 2343: from okc_rules_b sll,

2339: SELECT add_months(NVL(date_last_interim_interest_cal, start_date), decode(pay_freq, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, 1)) next_reamort_date
2340: FROM okl_k_headers_full_v khr,
2341: (Select distinct rgp.dnz_chr_id khr_id
2342: ,sll.object1_id1 Pay_freq
2343: from okc_rules_b sll,
2344: okc_rules_b slh,
2345: okl_strm_type_b styp,
2346: okc_rule_groups_b rgp
2347: where to_number(sll.object2_id1) = slh.id

Line 2344: okc_rules_b slh,

2340: FROM okl_k_headers_full_v khr,
2341: (Select distinct rgp.dnz_chr_id khr_id
2342: ,sll.object1_id1 Pay_freq
2343: from okc_rules_b sll,
2344: okc_rules_b slh,
2345: okl_strm_type_b styp,
2346: okc_rule_groups_b rgp
2347: where to_number(sll.object2_id1) = slh.id
2348: and sll.rule_information_category = 'LASLL'

Line 3158: FROM okc_rules_b rule,

3154:
3155: -- Derive print lead days from the rules
3156: CURSOR c_lead_days(p_khr_id IN NUMBER) IS
3157: SELECT rule_information3
3158: FROM okc_rules_b rule,
3159: okc_rule_groups_b rgp
3160: WHERE rgp.id = rule.rgp_id
3161: AND rgp.dnz_chr_id = p_khr_id
3162: AND rgd_code = 'LABILL'

Line 5446: from okc_rules_b sll_rulb,

5442: -- Declare payment frequency cursor
5443: -----------------------------------------------------------------
5444: CURSOR c_pay_freq(cp_khr_id NUMBER) IS
5445: select sll_rulb.object1_id1 pay_freq
5446: from okc_rules_b sll_rulb,
5447: okc_rules_b slh_rulb,
5448: okl_strm_type_b styb,
5449: okc_rule_groups_b rgpb
5450: where sll_rulb.rgp_id = rgpb.id

Line 5447: okc_rules_b slh_rulb,

5443: -----------------------------------------------------------------
5444: CURSOR c_pay_freq(cp_khr_id NUMBER) IS
5445: select sll_rulb.object1_id1 pay_freq
5446: from okc_rules_b sll_rulb,
5447: okc_rules_b slh_rulb,
5448: okl_strm_type_b styb,
5449: okc_rule_groups_b rgpb
5450: where sll_rulb.rgp_id = rgpb.id
5451: and sll_rulb.rule_information_category = 'LASLL'

Line 8952: from okc_rules_b sll_rulb,

8948: slh_rulb.jtot_object2_code time_value,
8949: slh_rulb.object1_id1 sty_id,
8950: slh_rulb.rule_information1 billing_schedule_type,
8951: slh_rulb.rule_information2 rate_type
8952: from okc_rules_b sll_rulb,
8953: okc_rules_b slh_rulb,
8954: okl_strm_type_b styb,
8955: okc_rule_groups_b rgpb
8956: where sll_rulb.rgp_id = rgpb.id

Line 8953: okc_rules_b slh_rulb,

8949: slh_rulb.object1_id1 sty_id,
8950: slh_rulb.rule_information1 billing_schedule_type,
8951: slh_rulb.rule_information2 rate_type
8952: from okc_rules_b sll_rulb,
8953: okc_rules_b slh_rulb,
8954: okl_strm_type_b styb,
8955: okc_rule_groups_b rgpb
8956: where sll_rulb.rgp_id = rgpb.id
8957: and sll_rulb.rule_information_category = 'LASLL'

Line 8981: select object1_id1 from okc_rules_b

8977: FROM okl_k_headers_full_v
8978: WHERE id = p_chr_id;
8979:
8980: CURSOR c_freq_cur(p_contract_id NUMBER) IS
8981: select object1_id1 from okc_rules_b
8982: where dnz_chr_id = p_contract_id
8983: and rule_information_category = 'LASLL';
8984:
8985: l_pymt_rec l_pmt_csr%RowType;

Line 9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;

8998: l_period_cntr NUMBER := 0;
8999: l_prior_level_date_start DATE;
9000: l_level_date_start DATE;
9001: l_sequence NUMBER := 0;
9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;
9004: l_tuoms_per_period okc_rules_b.rule_information4%type;
9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
9006: l_structure okc_rules_b.rule_information5%type;

Line 9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;

8999: l_prior_level_date_start DATE;
9000: l_level_date_start DATE;
9001: l_sequence NUMBER := 0;
9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;
9004: l_tuoms_per_period okc_rules_b.rule_information4%type;
9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
9006: l_structure okc_rules_b.rule_information5%type;
9007:

Line 9004: l_tuoms_per_period okc_rules_b.rule_information4%type;

9000: l_level_date_start DATE;
9001: l_sequence NUMBER := 0;
9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;
9004: l_tuoms_per_period okc_rules_b.rule_information4%type;
9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
9006: l_structure okc_rules_b.rule_information5%type;
9007:
9008: l_stub_start_date DATE;

Line 9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;

9001: l_sequence NUMBER := 0;
9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;
9004: l_tuoms_per_period okc_rules_b.rule_information4%type;
9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
9006: l_structure okc_rules_b.rule_information5%type;
9007:
9008: l_stub_start_date DATE;
9009: l_stub_days NUMBER;

Line 9006: l_structure okc_rules_b.rule_information5%type;

9002: l_time_unit_of_measure okc_rules_b.jtot_object1_code%type;
9003: l_stream_level_header okc_rules_b.jtot_object2_code%type;
9004: l_tuoms_per_period okc_rules_b.rule_information4%type;
9005: l_sll_rule_information_cat okc_rules_b.rule_information_category%type;
9006: l_structure okc_rules_b.rule_information5%type;
9007:
9008: l_stub_start_date DATE;
9009: l_stub_days NUMBER;
9010: l_stub_amount NUMBER;

Line 10213: l_frequency okc_rules_b.object1_id1%type;

10209: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
10210: l_msg_index_out NUMBER;
10211: l_term_duration NUMBER;
10212: l_tot_principal_amount NUMBER := 0;
10213: l_frequency okc_rules_b.object1_id1%type;
10214: l_csm_line_details_ctr NUMBER;
10215: l_first_row NUMBER;
10216: l_loan_levels_cntr NUMBER;
10217: l_loan_levels_date_start DATE;

Line 10293: select object1_id1 from okc_rules_b

10289: WHERE K.id = p_contract_id
10290: and K.id = KHR.id;
10291:
10292: CURSOR c_freq_cur(p_contract_id NUMBER) IS
10293: select object1_id1 from okc_rules_b
10294: where dnz_chr_id = p_contract_id
10295: and rule_information_category = 'LASLL';
10296:
10297: -- Added by prasjain bug# 6142095