DBA Data[Home] [Help]

APPS.OKL_GENERATE_PV_RENT_PVT dependencies on OKC_RULES_B

Line 64: okc_rules_b rul1,

60: SELECT cle.id, sty.stream_type_purpose,
61: NVL(kle.capital_amount,0) capital_amount,
62: NVL(kle.residual_value, 0) residual_value
63: FROM okc_rule_groups_b rgp,
64: okc_rules_b rul1,
65: okc_k_lines_b cle,
66: okl_k_lines kle,
67: okc_line_styles_b lse,
68: okl_strm_type_b sty

Line 530: FROM okc_rules_b sll,

526: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
527: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
528: TO_NUMBER(sll.rule_information7) stub_days,
529: TO_NUMBER(sll.rule_information8) stub_amount
530: FROM okc_rules_b sll,
531: okc_rules_b slh,
532: okc_rule_groups_b rgp,
533: okl_strm_type_b sty
534: WHERE rgp.dnz_chr_id = p_khr_id

Line 531: okc_rules_b slh,

527: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
528: TO_NUMBER(sll.rule_information7) stub_days,
529: TO_NUMBER(sll.rule_information8) stub_amount
530: FROM okc_rules_b sll,
531: okc_rules_b slh,
532: okc_rule_groups_b rgp,
533: okl_strm_type_b sty
534: WHERE rgp.dnz_chr_id = p_khr_id
535: AND rgp.cle_id = p_kle_id