APPS.OKL_INVESTOR_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 95: Okc_rule_groups_B rgp

91: --COMMENTED OUT FOR RULES MIGRATION
92: /*CURSOR bill_site_rul_csr( p_invstr_agr_id NUMBER, p_top_line_id NUMBER ) IS
93: SELECT object1_id1
94: FROM OKC_RULES_B rul,
95: Okc_rule_groups_B rgp
96: WHERE rul.rgp_id = rgp.id AND
97: rgp.rgd_code = 'LABILL' AND
98: rgp.cle_id = p_top_line_id AND
99: rul.rule_information_category = 'BTO' AND

Line 137: Okc_rule_groups_B rgp

133: ------------------------------------------------------------
134: CURSOR rcpt_mthd_rul_csr( p_invstr_agr_id NUMBER, p_top_line_id NUMBER ) IS
135: SELECT object1_id1
136: FROM OKC_RULES_B rul,
137: Okc_rule_groups_B rgp
138: WHERE rul.rgp_id = rgp.id AND
139: rgp.rgd_code = 'LABILL' AND
140: rul.rule_information_category = 'LAPMTH' AND
141: rgp.cle_id = p_top_line_id AND

Line 163: Okc_rule_groups_B rgp

159: ------------------------------------------------------------
160: CURSOR bank_acct_rul_csr( p_invstr_agr_id NUMBER, p_top_line_id NUMBER ) IS
161: SELECT object1_id1
162: FROM OKC_RULES_B rul,
163: Okc_rule_groups_B rgp
164: WHERE rul.rgp_id = rgp.id AND
165: rgp.rgd_code = 'LABILL' AND
166: rgp.cle_id = p_top_line_id AND
167: rul.rule_information_category = 'LABACC' AND

Line 261: from okc_rule_groups_b rgp, okc_rules_b rul

257: ------------------------------------------------------------
258: -- bug#4643924 start cursor to fetch the special accounting code
259: CURSOR spl_acct_code_rul_csr( p_invstr_agr_id NUMBER) IS
260: select rul.rule_information1 investor_code
261: from okc_rule_groups_b rgp, okc_rules_b rul
262: where rgp.chr_id = rgp.dnz_chr_id
263: and rgp.dnz_chr_id = p_invstr_agr_id
264: and rgp.rgd_code = 'LASEAC'
265: and rul.dnz_chr_id = rgp.dnz_chr_id