APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_RULES_B

Line 241: FROM okc_rules_b a,

237: SELECT ste.amount
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

Line 308: FROM OKC_RULES_B rul,

304: ------------------------------------------------------------
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

Line 506: l_bill_freq OKC_RULES_B.object1_id1%TYPE;

502: l_max_line_num NUMBER;
503: l_rec_exists_cnt NUMBER;
504: l_prev_unbilled_cnt NUMBER;
505: l_investor_agrmt_id NUMBER;
506: l_bill_freq OKC_RULES_B.object1_id1%TYPE;
507: l_primary_sty_id NUMBER;
508: l_primary_for_dep_sty_id NUMBER;
509: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
510:

Line 1678: p_rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1682: DECODE(crl.object1_id1,'M',1,'Q',3,'S',6,'A',12) frequency_factor,

Line 1689: OKC_RULES_B crl

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
1693: and crl.RULE_INFORMATION_CATEGORY = p_rlcat

Line 1697: from okc_rules_b crl2

1693: and crl.RULE_INFORMATION_CATEGORY = p_rlcat
1694: and crg.dnz_chr_id = p_chrId
1695: and nvl(crg.cle_id,-1) = nvl(p_cleId, -1)
1696: and FND_DATE.canonical_to_date(crl.rule_information2) = (select max(FND_DATE.canonical_to_date(crl.RULE_INFORMATION2))
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,

Line 1702: p_rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1706: crl.object1_id1,

Line 1716: OKC_RULES_B crl,

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
1720: and crl.RULE_INFORMATION_CATEGORY = p_rlcat

Line 1730: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
1734: crl.object1_id1,

Line 1744: OKC_RULES_B crl

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
1748: and crg.dnz_chr_id = chrId

Line 1830: from okc_rules_b

1826: begin
1827:
1828: select nvl(rule_information1, 'N')
1829: into l_evergreen_eligible
1830: from okc_rules_b
1831: where rule_information_category = 'LAEVEL'
1832: and dnz_chr_id = p_chr_id
1833: and not exists (select '1'
1834: from okl_k_headers