APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKC_RULES_B

Line 3870: l_inv_acct_code okc_rules_b.rule_information1%TYPE;

3866: l_quote_eff_date DATE;
3867: -- rmunjulu 4622198
3868: l_scs_code okc_k_headers_b.scs_code%TYPE;
3869: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
3870: l_inv_acct_code okc_rules_b.rule_information1%TYPE;
3871:
3872: --akrangan Bug 5514059 start
3873: -- Used to get Assets selected for termination and
3874: -- Fee and Sold Service lines associated to the assets

Line 9674: FROM okc_rules_b sll_rul,

9670: sttyp.id1 sty_id,
9671: sll_rul.rule_information5 advance_periods,
9672: sll_rul.rule_information10 due_arrears_yn,
9673: sll_rul.object1_id1 frequency
9674: FROM okc_rules_b sll_rul,
9675: okc_rules_b slh_rul,
9676: okc_rule_groups_b rgp,
9677: okl_strmtyp_source_v sttyp
9678: WHERE sll_rul.object2_id1 = TO_CHAR (slh_rul.ID)

Line 9675: okc_rules_b slh_rul,

9671: sll_rul.rule_information5 advance_periods,
9672: sll_rul.rule_information10 due_arrears_yn,
9673: sll_rul.object1_id1 frequency
9674: FROM okc_rules_b sll_rul,
9675: okc_rules_b slh_rul,
9676: okc_rule_groups_b rgp,
9677: okl_strmtyp_source_v sttyp
9678: WHERE sll_rul.object2_id1 = TO_CHAR (slh_rul.ID)
9679: AND sll_rul.rgp_id = rgp.ID

Line 9728: FROM okc_rules_b sll_rul,

9724: sll_rul.rule_information6 amount,
9725: sll_rul.rule_information7 stub_days,
9726: sll_rul.rule_information8 stub_amount,
9727: rgp.dnz_chr_id
9728: FROM okc_rules_b sll_rul,
9729: okl_strmtyp_source_v sttyp,
9730: okc_rules_b slh_rul,
9731: okc_rule_groups_b rgp
9732: WHERE sll_rul.object2_id1 = TO_CHAR (slh_rul.ID)

Line 9730: okc_rules_b slh_rul,

9726: sll_rul.rule_information8 stub_amount,
9727: rgp.dnz_chr_id
9728: FROM okc_rules_b sll_rul,
9729: okl_strmtyp_source_v sttyp,
9730: okc_rules_b slh_rul,
9731: okc_rule_groups_b rgp
9732: WHERE sll_rul.object2_id1 = TO_CHAR (slh_rul.ID)
9733: AND sll_rul.rgp_id = rgp.ID
9734: AND sll_rul.rule_information_category = 'LASLL'

Line 11303: okc_rules_b rl,

11299: IS
11300: SELECT rl.ID ID,
11301: rl.rule_information6 payment_amount
11302: FROM okc_rule_groups_b rg,
11303: okc_rules_b rl,
11304: okc_k_lines_v cle,
11305: okc_line_styles_b lse
11306: WHERE cle.dnz_chr_id = p_chr_id
11307: AND cle.ID = p_cle_id