DBA Data[Home] [Help]

APPS.OKL_LA_JE_PVT dependencies on OKC_RULES_B

Line 55: FROM OKC_RULES_B rul

51: FROM okc_k_headers_b CHR
52: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
53: and chr.ID = p_chr_id
54: AND exists (SELECT '1'
55: FROM OKC_RULES_B rul
56: WHERE rul.dnz_chr_id = chr.id
57: AND rul.rule_information_category = 'LARLES'
58: AND nvl(rule_information1,'N') = 'Y');
59:

Line 168: from okc_rules_b rul

164: /* Rule migration - BTO
165:
166: Cursor custBillTo_csr( chrId NUMBER) IS
167: select object1_id1 cust_acct_site_id
168: from okc_rules_b rul
169: where rul.rule_information_category = 'BTO'
170: and exists (select '1'
171: from okc_rule_groups_b rgp
172: where rgp.id = rul.rgp_id

Line 276: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

272: --Bug# 3153003
273:
274: --Bug# 4622198
275: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
276: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
277: --Bug# 4622198
278:
279: --Added by dpsingh for LE uptake
280: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS