APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_RULE_GROUPS_B

Line 123: okc_rule_groups_b rgp

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'
126: and sll.dnz_chr_id = rgp.dnz_chr_id
127: and sll.rgp_id = rgp.id

Line 164: okc_rule_groups_b rgp

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'
167: and sll.dnz_chr_id = rgp.dnz_chr_id
168: and sll.rgp_id = rgp.id

Line 2306: okc_rule_groups_b rgp

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')
2310: AND chr.id = khr.id

Line 2346: okc_rule_groups_b rgp

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'
2349: and sll.dnz_chr_id = rgp.dnz_chr_id
2350: and sll.rgp_id = rgp.id

Line 3159: okc_rule_groups_b rgp

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'
3163: AND rule_information_category = 'LAINVD';

Line 5449: okc_rule_groups_b rgpb

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'
5452: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
5453: and sll_rulb.object2_id1 = to_char(slh_rulb.id)

Line 8955: okc_rule_groups_b rgpb

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'
8958: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
8959: and sll_rulb.object2_id1 = to_char(slh_rulb.id)