APPS.OKL_LOAN_AMORT_SCHEDULE_PVT dependencies on OKC_RULES_B

Line 92: FROM okc_rules_b sll,

88: TO_NUMBER(sll.rule_information7) stub_days,
89: TO_NUMBER(sll.rule_information3) periods,
90: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12) frequency,
91: sll.rule_information10 arrears_yn
92: FROM okc_rules_b sll,
93: okc_rules_b slh,
94: okc_rule_groups_b rgp,
95: okl_strm_type_b sty
96: WHERE rgp.dnz_chr_id = p_chr_id

Line 93: okc_rules_b slh,

89: TO_NUMBER(sll.rule_information3) periods,
90: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12) frequency,
91: sll.rule_information10 arrears_yn
92: FROM okc_rules_b sll,
93: okc_rules_b slh,
94: okc_rule_groups_b rgp,
95: okl_strm_type_b sty
96: WHERE rgp.dnz_chr_id = p_chr_id
97: AND rgp.cle_id = p_cle_id

Line 2582: okc_rules_b rulb,

2578: rulb2.object1_id1 frequency,
2579: cleb.sts_code sts_code
2580: FROM okc_k_lines_b cleb,
2581: okc_rule_groups_b rgpb,
2582: okc_rules_b rulb,
2583: okc_rules_b rulb2,
2584: okl_strm_type_b styb,
2585: okc_statuses_b sts
2586: WHERE rgpb.chr_id IS NULL

Line 2583: okc_rules_b rulb2,

2579: cleb.sts_code sts_code
2580: FROM okc_k_lines_b cleb,
2581: okc_rule_groups_b rgpb,
2582: okc_rules_b rulb,
2583: okc_rules_b rulb2,
2584: okl_strm_type_b styb,
2585: okc_statuses_b sts
2586: WHERE rgpb.chr_id IS NULL
2587: AND rgpb.dnz_chr_id = cleb.dnz_chr_id