APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULES_B

Line 619: FROM OKC_K_HEADERS_B CHR,okc_rule_groups_b RGP,okc_rules_b RUL

615: AND NVL (ste.amount, 0) <> 0;
616: --rkuttiya modifed for bug # 5031455 join condition of cursor to use dnz_chr_id instead of chr_id
617: CURSOR Interest_Type IS
618: SELECT DECODE(rule_information1, 'Y', 'Variable', 'N', 'Fixed', 'Unknown')
619: FROM OKC_K_HEADERS_B CHR,okc_rule_groups_b RGP,okc_rules_b RUL
620: WHERE CHR.ID = RGP.DNZ_CHR_ID AND
621: --CHR.ID = RGP.CHR_ID AND
622: RGP.ID = RUL.RGP_ID AND
623: RUL.rule_information_category = 'LAINTP' AND

Line 1746: from okc_rules_b

1742: IS
1743: l_tax_Sch_req VARCHAR2(30) := 'N';
1744: CURSOR get_taxsch_rule_csr IS
1745: select rule_information5
1746: from okc_rules_b
1747: where dnz_chr_id = p_contract_id
1748: and rule_information_category = 'LASTPR';
1749: BEGIN
1750: OPEN get_taxsch_rule_csr;

Line 1858: OKC_RULES_B RUL_LASLH,

1854: FND_DATE.canonical_to_date(rul_lasll.rule_information2) start_date,
1855: rul_lasll.rule_information7 stub_days,
1856: rul_lasll.rule_information3 periods
1857: FROM OKC_RULE_GROUPS_B RGP_LALEVL,
1858: OKC_RULES_B RUL_LASLH,
1859: OKC_RULES_B RUL_LASLL,
1860: OKL_STRM_TYPE_v STYT
1861: WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
1862: AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID

Line 1859: OKC_RULES_B RUL_LASLL,

1855: rul_lasll.rule_information7 stub_days,
1856: rul_lasll.rule_information3 periods
1857: FROM OKC_RULE_GROUPS_B RGP_LALEVL,
1858: OKC_RULES_B RUL_LASLH,
1859: OKC_RULES_B RUL_LASLL,
1860: OKL_STRM_TYPE_v STYT
1861: WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
1862: AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID
1863: AND RUL_LASLH.RULE_INFORMATION_CATEGORY = 'LASLH'