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

Line 32: okc_rules_b rulb,

28: rulb2.RULE_INFORMATION7 stub_days,
29: rulb2.RULE_INFORMATION8 stub_amount,
30: rulb2.object1_id1 frequency
31: FROM okc_rule_groups_b rgpb,
32: okc_rules_b rulb,
33: okc_rules_b rulb2,
34: okl_strm_type_b styb
35: WHERE rgpb.chr_id = p_contract_id
36: AND rgpb.dnz_chr_id = p_contract_id

Line 33: okc_rules_b rulb2,

29: rulb2.RULE_INFORMATION8 stub_amount,
30: rulb2.object1_id1 frequency
31: FROM okc_rule_groups_b rgpb,
32: okc_rules_b rulb,
33: okc_rules_b rulb2,
34: okl_strm_type_b styb
35: WHERE rgpb.chr_id = p_contract_id
36: AND rgpb.dnz_chr_id = p_contract_id
37: AND rgpb.rgd_code = 'LALEVL'

Line 50: okc_rules_b rulb,

46:
47: CURSOR l_periods_csr(p_contract_id NUMBER) IS
48: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION3) * DECODE(rulb2.object1_id1,'M',1,'Q',3,'S',6,'A',12) * 30),0)
49: FROM okc_rule_groups_b rgpb,
50: okc_rules_b rulb,
51: okc_rules_b rulb2,
52: okl_strm_type_b styb
53: WHERE rgpb.chr_id = p_contract_id
54: AND rgpb.dnz_chr_id = p_contract_id

Line 51: okc_rules_b rulb2,

47: CURSOR l_periods_csr(p_contract_id NUMBER) IS
48: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION3) * DECODE(rulb2.object1_id1,'M',1,'Q',3,'S',6,'A',12) * 30),0)
49: FROM okc_rule_groups_b rgpb,
50: okc_rules_b rulb,
51: okc_rules_b rulb2,
52: okl_strm_type_b styb
53: WHERE rgpb.chr_id = p_contract_id
54: AND rgpb.dnz_chr_id = p_contract_id
55: AND rgpb.rgd_code = 'LALEVL'

Line 68: okc_rules_b rulb,

64:
65: CURSOR l_stubs_csr(p_contract_id NUMBER) IS
66: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION7)),0)
67: FROM okc_rule_groups_b rgpb,
68: okc_rules_b rulb,
69: okc_rules_b rulb2,
70: okl_strm_type_b styb
71: WHERE rgpb.chr_id = p_contract_id
72: AND rgpb.dnz_chr_id = p_contract_id

Line 69: okc_rules_b rulb2,

65: CURSOR l_stubs_csr(p_contract_id NUMBER) IS
66: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION7)),0)
67: FROM okc_rule_groups_b rgpb,
68: okc_rules_b rulb,
69: okc_rules_b rulb2,
70: okl_strm_type_b styb
71: WHERE rgpb.chr_id = p_contract_id
72: AND rgpb.dnz_chr_id = p_contract_id
73: AND rgpb.rgd_code = 'LALEVL'

Line 85: l_frequency okc_rules_b.object1_id1%type;

81: AND styb.STREAM_TYPE_PURPOSE = 'VARIABLE_INTEREST_SCHEDULE';
82:
83: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
84: l_recurrence_date DATE := NULL;
85: l_frequency okc_rules_b.object1_id1%type;
86: l_adder_months NUMBER := 0;
87:
88: l_chr_term_days NUMBER := 0;
89: l_chr_period_days NUMBER := 0;

Line 1079: okc_rules_b rul1,

1075: --Bug# 13026821
1076: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
1077: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1078: FROM okc_rule_groups_b rgp,
1079: okc_rules_b rul1,
1080: okc_rules_b rul2,
1081: okl_strm_type_b sty
1082: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1083: AND rul2.rule_information_category = 'LASLL'

Line 1080: okc_rules_b rul2,

1076: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
1077: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1078: FROM okc_rule_groups_b rgp,
1079: okc_rules_b rul1,
1080: okc_rules_b rul2,
1081: okl_strm_type_b sty
1082: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1083: AND rul2.rule_information_category = 'LASLL'
1084: AND rul2.rgp_id = rgp.id