APPS.OKL_VAR_INT_FLOAT_PVT dependencies on OKC_RULE_GROUPS_B

Line 31: FROM okc_rule_groups_b rgpb,

27: rulb2.RULE_INFORMATION3 level_periods,
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

Line 49: FROM okc_rule_groups_b rgpb,

45: ORDER BY start_date;
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

Line 67: FROM okc_rule_groups_b rgpb,

63: AND styb.STREAM_TYPE_PURPOSE = 'VARIABLE_INTEREST_SCHEDULE';
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

Line 1078: FROM okc_rule_groups_b rgp,

1074:
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