[Home] [Help]
355: okl_K_lines_full_v kle,
356: okc_statuses_b sts,
357: okl_strm_elements sel,
358: okl_streams stm,
359: okl_strm_type_b sty
360: WHERE kle.dnz_chr_id = p_chr_id
361: AND kle.id = p_kle_id
362: AND kle.sts_code = sts.code
363: AND sts.ste_code NOT IN ('TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
376: Cursor l_chr_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2) IS
377: SELECT NVL(SUM(sele.amount),0) amount
378: FROM okl_strm_elements sele,
379: okl_streams str,
380: okl_strm_type_b sty
381: WHERE sele.stm_id = str.id
382: AND str.sty_id = sty.id
383: AND sty.stream_type_purpose = 'RENT'
384: AND str.say_code = 'CURR'
448: okl_K_lines_full_v kle,
449: okc_statuses_b sts,
450: okl_strm_elements sel,
451: okl_streams stm,
452: okl_strm_type_b sty
453: WHERE kle.dnz_chr_id = p_chr_id
454: AND kle.id = p_kle_id
455: AND kle.sts_code = sts.code
456: AND sts.ste_code NOT IN ('TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
784: slh_rulb.rule_information1 billing_schedule_type,
785: slh_rulb.rule_information2 rate_type
786: from okc_rules_b sll_rulb,
787: okc_rules_b slh_rulb,
788: okl_strm_type_b styb,
789: okc_rule_groups_b rgpb
790: where sll_rulb.rgp_id = rgpb.id
791: and sll_rulb.rule_information_category = 'LASLL'
792: and sll_rulb.dnz_chr_id = rgpb.dnz_chr_id
818: SELECT rul2.object1_id1
819: FROM okc_rule_groups_b rgp,
820: okc_rules_b rul1,
821: okc_rules_b rul2,
822: okl_strm_type_b sty
823: WHERE rul2.dnz_chr_id = p_contract_id
824: AND rul2.rule_information_category = 'LASLL'
825: AND rul2.rgp_id = rgp.id
826: AND TO_NUMBER(rul2.object2_id1) = rul1.id
1608: SELECT rul2.object1_id1
1609: FROM okc_rule_groups_b rgp,
1610: okc_rules_b rul1,
1611: okc_rules_b rul2,
1612: okl_strm_type_b sty
1613: WHERE rul2.dnz_chr_id = p_contract_id
1614: AND rul2.rule_information_category = 'LASLL'
1615: AND rul2.rgp_id = rgp.id
1616: AND TO_NUMBER(rul2.object2_id1) = rul1.id