DBA Data[Home] [Help]

APPS.OKL_LOAN_AMORT_SCHEDULE_PVT dependencies on OKC_STATUSES_B

Line 76: okc_statuses_b sts

72:
73: CURSOR fin_cle_csr(p_chr_id IN NUMBER) IS
74: SELECT cleb_fin.id
75: FROM okc_k_lines_b cleb_fin,
76: okc_statuses_b sts
77: WHERE cleb_fin.dnz_chr_id = p_chr_id
78: AND cleb_fin.chr_id = p_chr_id
79: AND cleb_fin.lse_id = 33
80: AND cleb_fin.sts_code = sts.code

Line 2585: okc_statuses_b sts

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
2588: AND rgpb.cle_id = cleb.id
2589: AND cleb.dnz_chr_id = p_chr_id