APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_RULES_B

Line 149: FROM okc_rules_b rul

145: l_trx_type NUMBER;
146:
147: Cursor Billto_csr(v_khr_id NUMBER) IS
148: SELECT object1_id1 cust_acct_site_id
149: FROM okc_rules_b rul
150: WHERE rul.rule_information_category = 'BTO'
151: and exists (select '1'
152: from okc_rule_groups_b rgp
153: where rgp.id = rul.rgp_id

Line 158: l_ar_site_use OKC_RULES_B.object1_id1%TYPE;

154: and rgp.rgd_code = 'LABILL'
155: and rgp.chr_id = rul.dnz_chr_id
156: and rgp.chr_id = v_khr_id );
157:
158: l_ar_site_use OKC_RULES_B.object1_id1%TYPE;
159: -- Added by dpsingh for LE Uptake
160: -- cursor to get the contract number
161: CURSOR contract_num_csr (p_ctr_id NUMBER) IS
162: SELECT contract_number

Line 366: FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp

362: -- Modified cursor to fetch Index Name from Prefunding Terms
363: -- and Conditions
364: CURSOR indx_csr(p_chr_id IN NUMBER) IS
365: SELECT idx.name
366: FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp
367: WHERE rule.rule_information_category = 'LAIVAR'
368: AND rule.dnz_chr_id = p_chr_id
369: AND rule.rule_information2 = idx.id
370: AND rule.rgp_id = rgp.id

Line 726: OKC_RULES_B rule

722: oklh.pdt_id pdt_id,
723: okch.start_date start_date
724: FROM OKL_K_HEADERS oklh,
725: OKC_K_HEADERS_B okch,
726: OKC_RULES_B rule
727: WHERE okch.sts_code IN ('ENTERED', 'COMPLETE','PASSED','INCOMPLETE','PENDING_APPROVAL',
728: 'APPROVED')
729: AND oklh.id = okch.id
730: AND rule.DNZ_CHR_ID = oklh.id

Line 1035: FROM OKC_RULES_B

1031:
1032: -- Cursor for getting the capitalization flag information
1033: CURSOR captl_csr(v_khr_id NUMBER) IS
1034: SELECT rule_information1
1035: FROM OKC_RULES_B
1036: WHERE DNZ_CHR_ID = v_khr_id
1037: AND rule_information_category = 'LACPLN';
1038:
1039: -- Cursor for getting OEC and then updating the CAPITALIZED_INTEREST field