APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULES_B

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

577: AND NVL (ste.amount, 0) <> 0;
578: --rkuttiya modifed for bug # 5031455 join condition of cursor to use dnz_chr_id instead of chr_id
579: CURSOR Interest_Type IS
580: SELECT DECODE(rule_information1, 'Y', 'Variable', 'N', 'Fixed', 'Unknown')
581: FROM OKC_K_HEADERS_B CHR,okc_rule_groups_b RGP,okc_rules_b RUL
582: WHERE CHR.ID = RGP.DNZ_CHR_ID AND
583: --CHR.ID = RGP.CHR_ID AND
584: RGP.ID = RUL.RGP_ID AND
585: RUL.rule_information_category = 'LAINTP' AND

Line 1708: from okc_rules_b

1704: IS
1705: l_tax_Sch_req VARCHAR2(30) := 'N';
1706: CURSOR get_taxsch_rule_csr IS
1707: select rule_information5
1708: from okc_rules_b
1709: where dnz_chr_id = p_contract_id
1710: and rule_information_category = 'LASTPR';
1711: BEGIN
1712: OPEN get_taxsch_rule_csr;

Line 1820: OKC_RULES_B RUL_LASLH,

1816: FND_DATE.canonical_to_date(rul_lasll.rule_information2) start_date,
1817: rul_lasll.rule_information7 stub_days,
1818: rul_lasll.rule_information3 periods
1819: FROM OKC_RULE_GROUPS_B RGP_LALEVL,
1820: OKC_RULES_B RUL_LASLH,
1821: OKC_RULES_B RUL_LASLL,
1822: OKL_STRM_TYPE_v STYT
1823: WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
1824: AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID

Line 1821: OKC_RULES_B RUL_LASLL,

1817: rul_lasll.rule_information7 stub_days,
1818: rul_lasll.rule_information3 periods
1819: FROM OKC_RULE_GROUPS_B RGP_LALEVL,
1820: OKC_RULES_B RUL_LASLH,
1821: OKC_RULES_B RUL_LASLL,
1822: OKL_STRM_TYPE_v STYT
1823: WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
1824: AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID
1825: AND RUL_LASLH.RULE_INFORMATION_CATEGORY = 'LASLH'