APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKC_RULE_GROUPS_B

Line 63: okc_rule_groups_b rgp

59: rgp.cle_id cle_id
60: from okc_rules_b sll,
61: okc_rules_b slh,
62: okl_strm_type_v styp,
63: okc_rule_groups_b rgp
64: where to_number(sll.object2_id1) = slh.id
65: and sll.rule_information_category = 'LASLL'
66: and sll.dnz_chr_id = rgp.dnz_chr_id
67: and sll.rgp_id = rgp.id

Line 305: okc_rule_groups_b rgp

301: sll.rule_information8 stub_amount
302: from okc_rules_b sll,
303: okc_rules_b slh,
304: okl_strm_type_v styp,
305: okc_rule_groups_b rgp
306: where to_number(sll.object2_id1) = slh.id
307: and sll.rule_information_category = 'LASLL'
308: and sll.dnz_chr_id = rgp.dnz_chr_id
309: and sll.rgp_id = rgp.id

Line 789: okc_rule_groups_b rgpb

785: slh_rulb.rule_information2 rate_type
786: from okc_rules_b sll_rulb,
787: okc_rules_b slh_rulb,
788: okl_strm_type_b styb,
789: okc_rule_groups_b rgpb
790: where sll_rulb.rgp_id = rgpb.id
791: and sll_rulb.rule_information_category = 'LASLL'
792: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
793: and sll_rulb.object2_id1 = to_char(slh_rulb.id)

Line 819: FROM okc_rule_groups_b rgp,

815: -- Payment Levels of Rent/Principal Payment/Loan Payment of Assets only
816: CURSOR c_freq_cur(p_contract_id NUMBER, p_cle_id IN NUMBER)
817: IS
818: SELECT rul2.object1_id1
819: FROM okc_rule_groups_b rgp,
820: okc_rules_b rul1,
821: okc_rules_b rul2,
822: okl_strm_type_b sty
823: WHERE rul2.dnz_chr_id = p_contract_id

Line 1609: FROM okc_rule_groups_b rgp,

1605: -- 10367844: Modified Cursor to fetch Frequency of
1606: -- Payment Levels of Rent/Principal Payment/Loan Payment of Assets only
1607: CURSOR c_freq_cur(p_contract_id NUMBER) IS
1608: SELECT rul2.object1_id1
1609: FROM okc_rule_groups_b rgp,
1610: okc_rules_b rul1,
1611: okc_rules_b rul2,
1612: okl_strm_type_b sty
1613: WHERE rul2.dnz_chr_id = p_contract_id