DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_RULE_GROUPS_B

Line 172: from okc_rule_groups_b rgp

168: select object1_id1 cust_acct_site_id
169: from okc_rules_b rul
170: where rul.rule_information_category = 'BTO'
171: and exists (select '1'
172: from okc_rule_groups_b rgp
173: where rgp.id = rul.rgp_id
174: and rgp.rgd_code = 'LABILL'
175: and rgp.dnz_chr_id = chrId );
176:

Line 234: okc_rule_groups_b rgp

230: -- investor code for agreement special accounting
231: CURSOR special_acct_rec_csr( chrId NUMBER) IS
232: SELECT rul.rule_information1 investor_code
233: FROM okc_rules_b rul,
234: okc_rule_groups_b rgp
235: WHERE rgp.id = rul.rgp_id
236: AND rul.rule_information_category = G_RULE_GRP_LASEAC --'LASEAC'
237: AND rgp.rgd_code = G_RULE_LASEAC --'LASEAC'
238: AND rul.dnz_chr_id = chrId