APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_RULES_B

Line 143: FROM okc_rules_b rul

139: l_trx_type NUMBER;
140:
141: Cursor Billto_csr(v_khr_id NUMBER) IS
142: SELECT object1_id1 cust_acct_site_id
143: FROM okc_rules_b rul
144: WHERE rul.rule_information_category = 'BTO'
145: and exists (select '1'
146: from okc_rule_groups_b rgp
147: where rgp.id = rul.rgp_id

Line 152: l_ar_site_use OKC_RULES_B.object1_id1%TYPE;

148: and rgp.rgd_code = 'LABILL'
149: and rgp.chr_id = rul.dnz_chr_id
150: and rgp.chr_id = v_khr_id );
151:
152: l_ar_site_use OKC_RULES_B.object1_id1%TYPE;
153: -- Added by dpsingh for LE Uptake
154: -- cursor to get the contract number
155: CURSOR contract_num_csr (p_ctr_id NUMBER) IS
156: SELECT contract_number

Line 876: OKC_RULES_B rule

872: oklh.pdt_id pdt_id,
873: okch.start_date start_date
874: FROM OKL_K_HEADERS oklh,
875: OKC_K_HEADERS_B okch,
876: OKC_RULES_B rule
877: WHERE okch.sts_code IN ('ENTERED', 'COMPLETE','PASSED','INCOMPLETE','PENDING_APPROVAL',
878: 'APPROVED')
879: AND oklh.id = okch.id
880: AND rule.DNZ_CHR_ID = oklh.id

Line 1183: FROM OKC_RULES_B

1179:
1180: -- Cursor for getting the capitalization flag information
1181: CURSOR captl_csr(v_khr_id NUMBER) IS
1182: SELECT rule_information1
1183: FROM OKC_RULES_B
1184: WHERE DNZ_CHR_ID = v_khr_id
1185: AND rule_information_category = 'LACPLN';
1186:
1187: -- Cursor for getting OEC and then updating the CAPITALIZED_INTEREST field