3110:
3111: --cursor to get maximum subsidy term
3112: cursor l_sub_csr (p_cle_id in number) is
3113: select subb.maximum_term
3114: from okl_subsidies_b subb,
3115: okl_k_lines kle
3116: where subsidy_id = kle.subsidy_id
3117: and kle.id = p_cle_id;
3118:
3115: okl_k_lines kle
3116: where subsidy_id = kle.subsidy_id
3117: and kle.id = p_cle_id;
3118:
3119: l_max_subsidy_term okl_subsidies_b.maximum_term%TYPE;
3120: --Bug# 3143522 : subsidies
3121:
3122: --Bug# 3180583
3123: l_multigaap_yn varchar2(1) default Null;