APPS.OKL_SIX_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 1194: NVL(cv_get_sub_dates.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN

1190: OPEN c_get_sub_dates_csr;
1191: FETCH c_get_sub_dates_csr INTO cv_get_sub_dates;
1192: CLOSE c_get_sub_dates_csr;
1193: IF(NOT p_sixv_rec.source_trx_date BETWEEN cv_get_sub_dates.effective_from_date AND
1194: NVL(cv_get_sub_dates.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN
1195: OKC_API.set_message(G_APP_NAME, G_SOURCE_TRX_DATE_SUB_VAL, 'TRX_DATE', p_sixv_rec.source_trx_date, 'SUBSIDY', cv_get_sub_dates.name);
1196: l_return_status := OKC_API.G_RET_STS_ERROR;
1197: END IF;
1198: OPEN c_get_sub_pool_dates_csr;

Line 1202: NVL(cv_get_sub_pool_dates.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN

1198: OPEN c_get_sub_pool_dates_csr;
1199: FETCH c_get_sub_pool_dates_csr INTO cv_get_sub_pool_dates;
1200: CLOSE c_get_sub_pool_dates_csr;
1201: IF(NOT p_sixv_rec.source_trx_date BETWEEN cv_get_sub_pool_dates.effective_from_date AND
1202: NVL(cv_get_sub_pool_dates.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN
1203: OKC_API.set_message(G_APP_NAME, G_SOURCE_TRX_DATE_POOL_VAL, 'TRX_DATE', p_sixv_rec.source_trx_date, 'SUB_POOL', cv_get_sub_pool_dates.subsidy_pool_name);
1204: l_return_status := OKC_API.G_RET_STS_ERROR;
1205: END IF;
1206: