APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 564: okc_rule_groups_b org1

560: o_interest_type OUT NOCOPY VARCHAR2) IS
561: CURSOR advance_rent IS
562: SELECT SUM(NVL(orv1.rule_information6,0))
563: FROM okc_rules_v orv1,
564: okc_rule_groups_b org1
565: WHERE org1.dnz_chr_id = p_contract_id
566: and org1.dnz_chr_id = org1.chr_id
567: AND org1.id = orv1.rgp_id
568: AND orv1.rule_information_category = 'LASLL'

Line 572: okc_rule_groups_b org,

568: AND orv1.rule_information_category = 'LASLL'
569: AND exists
570: ( SELECT 'x'
571: FROM okc_k_headers_v okhdr,
572: okc_rule_groups_b org,
573: okc_rules_v orv,
574: OKL_STRMTYP_SOURCE_V stm
575: WHERE okhdr.id = org1.dnz_chr_id
576: and okhdr.id = org.dnz_chr_id

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 1857: FROM OKC_RULE_GROUPS_B RGP_LALEVL,

1853: NVL(RUL_LASLL.RULE_INFORMATION10,'N') ARREARS_YN,
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'