APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_RULES_B

Line 1785: FROM okc_rules_b sll,

1781: WHERE id = cp_khr_id;
1782:
1783: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1784: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1785: FROM okc_rules_b sll,
1786: okc_rules_b slh,
1787: okl_strm_type_v styp,
1788: okc_rule_groups_b rgp
1789: WHERE TO_NUMBER(sll.object2_id1) = slh.id

Line 1786: okc_rules_b slh,

1782:
1783: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1784: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq
1785: FROM okc_rules_b sll,
1786: okc_rules_b slh,
1787: okl_strm_type_v styp,
1788: okc_rule_groups_b rgp
1789: WHERE TO_NUMBER(sll.object2_id1) = slh.id
1790: AND sll.rule_information_category = 'LASLL'

Line 1831: okc_rules_b rul1,

1827: --Bug# 14049528
1828: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
1829: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1830: FROM okc_rule_groups_b rgp,
1831: okc_rules_b rul1,
1832: okc_rules_b rul2,
1833: okl_strm_type_b sty
1834: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1835: AND rul2.rule_information_category = 'LASLL'

Line 1832: okc_rules_b rul2,

1828: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
1829: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1830: FROM okc_rule_groups_b rgp,
1831: okc_rules_b rul1,
1832: okc_rules_b rul2,
1833: okl_strm_type_b sty
1834: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1835: AND rul2.rule_information_category = 'LASLL'
1836: AND rul2.rgp_id = rgp.id

Line 2363: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

2359: l_template_tbl OKL_ACCOUNT_DIST_PVT.AVLV_TBL_TYPE;
2360: l_tmpl_rec OKL_ACCOUNT_DIST_PVT.AVLV_REC_TYPE;
2361:
2362: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
2363: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
2364:
2365: l_api_version CONSTANT NUMBER := 1.0;
2366: x_msg_count NUMBER;
2367: x_msg_data VARCHAR2(2000);