DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_SUBSIDIES_B

Line 3114: from okl_subsidies_b subb,

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:

Line 3119: l_max_subsidy_term okl_subsidies_b.maximum_term%TYPE;

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;