DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_SUBSIDIES_B

Line 3035: from okl_subsidies_b subb,

3031:
3032: --cursor to get maximum subsidy term
3033: cursor l_sub_csr (p_cle_id in number) is
3034: select subb.maximum_term
3035: from okl_subsidies_b subb,
3036: okl_k_lines kle
3037: where subsidy_id = kle.subsidy_id
3038: and kle.id = p_cle_id;
3039:

Line 3040: l_max_subsidy_term okl_subsidies_b.maximum_term%TYPE;

3036: okl_k_lines kle
3037: where subsidy_id = kle.subsidy_id
3038: and kle.id = p_cle_id;
3039:
3040: l_max_subsidy_term okl_subsidies_b.maximum_term%TYPE;
3041: --Bug# 3143522 : subsidies
3042:
3043: --Bug# 3180583
3044: l_multigaap_yn varchar2(1) default Null;