APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKC_RULES_V

Line 525: FROM okc_rules_v orv1,

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

Line 535: okc_rules_v orv,

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