APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_RULE_GROUPS_B

Line 1087: okc_rule_groups_b rgp

1083: -- Derive print lead days from the rules
1084: CURSOR c_lead_days(p_khr_id IN NUMBER) IS
1085: SELECT rule_information3
1086: FROM okc_rules_b rule,
1087: okc_rule_groups_b rgp
1088: WHERE rgp.id = rule.rgp_id
1089: AND rgp.dnz_chr_id = p_khr_id
1090: AND rgd_code = 'LABILL'
1091: AND rule_information_category = 'LAINVD';

Line 2820: okc_rule_groups_b rgpb,

2816: rulb2.RULE_INFORMATION7 stub_days,
2817: rulb2.RULE_INFORMATION8 stub_amount,
2818: rulb2.object1_id1 frequency
2819: FROM okc_k_lines_b cleb,
2820: okc_rule_groups_b rgpb,
2821: okc_rules_b rulb,
2822: okc_rules_b rulb2,
2823: okl_strm_type_b styb
2824: WHERE rgpb.chr_id IS NULL

Line 3034: okc_rule_groups_b rgpb

3030: select sll_rulb.object1_id1 pay_freq
3031: from okc_rules_b sll_rulb,
3032: okc_rules_b slh_rulb,
3033: okl_strm_type_b styb,
3034: okc_rule_groups_b rgpb
3035: where sll_rulb.rgp_id = rgpb.id
3036: and sll_rulb.rule_information_category = 'LASLL'
3037: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
3038: and sll_rulb.object2_id1 = to_char(slh_rulb.id)

Line 6455: FROM okc_rule_groups_b rgp,

6451:
6452: --Bug# 13026821
6453: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
6454: SELECT NVL(rul2.rule_information10,'N') arrears_yn
6455: FROM okc_rule_groups_b rgp,
6456: okc_rules_b rul1,
6457: okc_rules_b rul2,
6458: okl_strm_type_b sty
6459: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id