APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULE_GROUPS_B

Line 526: okc_rule_groups_b org1

522: o_interest_type OUT NOCOPY VARCHAR2) IS
523: CURSOR advance_rent IS
524: SELECT SUM(NVL(orv1.rule_information6,0))
525: FROM okc_rules_v orv1,
526: okc_rule_groups_b org1
527: WHERE org1.dnz_chr_id = p_contract_id
528: and org1.dnz_chr_id = org1.chr_id
529: AND org1.id = orv1.rgp_id
530: AND orv1.rule_information_category = 'LASLL'

Line 534: okc_rule_groups_b org,

530: AND orv1.rule_information_category = 'LASLL'
531: AND exists
532: ( SELECT 'x'
533: FROM okc_k_headers_v okhdr,
534: okc_rule_groups_b org,
535: okc_rules_v orv,
536: OKL_STRMTYP_SOURCE_V stm
537: WHERE okhdr.id = org1.dnz_chr_id
538: and okhdr.id = org.dnz_chr_id

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

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