APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKC_RULES_B

Line 169: from okc_rules_b rul

165:
166:
167: Cursor custBillTo_csr( chrId NUMBER) IS
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

Line 233: FROM okc_rules_b rul,

229:
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'

Line 279: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

275: l_trx_desc VARCHAR2(2000);
276:
277: --Bug# 4622198
278: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
279: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
280: --Bug# 4622198
281: --
282: --Added by kthiruva for Bug 6354647
283: l_legal_entity_id NUMBER;