APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 242: okc_rule_groups_b b,

238: FROM okl_strm_elements ste,
239: (
240: SELECT stm.id, to_number(rule_information6) amt
241: FROM okc_rules_b a,
242: okc_rule_groups_b b,
243: okl_streams stm,
244: okl_strm_type_v sty
245: WHERE a.dnz_chr_id = p_khr_id
246: AND a.rgp_id = b.id

Line 309: Okc_rule_groups_B rgp

305: --changed for rules migration
306: CURSOR c_bill_freq_csr( p_khr_id NUMBER ) IS
307: SELECT object1_id1
308: FROM OKC_RULES_B rul,
309: Okc_rule_groups_B rgp
310: WHERE rul.rgp_id = rgp.id AND
311: rgp.rgd_code = 'LALEVL' AND
312: rgp.chr_id IS NULL AND
313: rul.rule_information_category = 'LASLL' AND

Line 1677: p_rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1673: AND kle.fee_type NOT IN ('FINANCED','ROLLOVER')
1674: AND sts.ste_code not in ( 'HOLD', 'EXPIRED', 'CANCELLED');
1675:
1676: cursor l_sll_csr( p_shid NUMBER,
1677: p_rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1678: p_rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1679: p_chrId NUMBER,
1680: p_cleId NUMBER ) IS
1681: select crl.id slh_id,

Line 1688: from OKC_RULE_GROUPS_B crg,

1684: TO_NUMBER(crl.RULE_INFORMATION3) periods,
1685: crl.RULE_INFORMATION5 structure,
1686: TO_NUMBER(crl.RULE_INFORMATION7) stub_days,
1687: crl.RULE_INFORMATION10 advance_arrears
1688: from OKC_RULE_GROUPS_B crg,
1689: OKC_RULES_B crl
1690: where crl.object2_id1 = p_shid
1691: and crl.rgp_id = crg.id
1692: and crg.RGD_CODE = p_rgcode

Line 1701: cursor l_asset_rl_csr1( p_rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1697: from okc_rules_b crl2
1698: where crl2.rgp_id = crl.rgp_id
1699: and crl2.RULE_INFORMATION_CATEGORY = crl.RULE_INFORMATION_CATEGORY);
1700:
1701: cursor l_asset_rl_csr1( p_rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1702: p_rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1703: p_chrId NUMBER,
1704: p_cleId NUMBER ) IS
1705: select crl.id slh_id,

Line 1715: from OKC_RULE_GROUPS_B crg,

1711: crl.RULE_INFORMATION6,
1712: crl.RULE_INFORMATION7,
1713: crl.RULE_INFORMATION8,
1714: crl.RULE_INFORMATION10
1715: from OKC_RULE_GROUPS_B crg,
1716: OKC_RULES_B crl,
1717: OKL_STRM_TYPE_B STY
1718: where crl.rgp_id = crg.id
1719: and crg.RGD_CODE = p_rgcode

Line 1729: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

1725: order by crl.RULE_INFORMATION1;
1726:
1727: l_asset_rl_rec l_asset_rl_csr1%ROWTYPE;
1728:
1729: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1730: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1731: chrId NUMBER,
1732: cleId NUMBER ) IS
1733: select crl.id slh_id,

Line 1743: from OKC_RULE_GROUPS_B crg,

1739: crl.RULE_INFORMATION6,
1740: crl.RULE_INFORMATION7,
1741: crl.RULE_INFORMATION8,
1742: crl.RULE_INFORMATION10
1743: from OKC_RULE_GROUPS_B crg,
1744: OKC_RULES_B crl
1745: where crl.rgp_id = crg.id
1746: and crg.RGD_CODE = rgcode
1747: and crl.RULE_INFORMATION_CATEGORY = rlcat