[Home] [Help]
90: ------------------------------------------------------------
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
132: -- Get Receipt Method Id
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
158: -- Get Bank Account Id
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
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
339: l_init_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
340:
341: l_acc_gen_wf_sources_rec OKL_ACCOUNT_GENERATOR_pvt.acc_gen_wf_sources_rec;
342:
343: l_inv_code okc_rules_b.RULE_INFORMATION1%TYPE;
344:
345: -------------------------------------------------------------------------
346: -- Legal Entity
347: -------------------------------------------------------------------------