DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULES_V

Line 563: FROM okc_rules_v orv1,

559: o_security_deposit OUT NOCOPY NUMBER,
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

Line 573: okc_rules_v orv,

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
577: and org.chr_id = org.dnz_chr_id