DBA Data[Home] [Help]

APPS.OKL_LRV_PVT dependencies on OKL_FE_ADJ_MAT_VERSIONS

Line 1043: FROM okl_fe_adj_mat_versions

1039: AND p_lrvv_rec.effective_from_date BETWEEN effective_from_date AND nvl(effective_to_date, p_lrvv_rec.effective_from_date + 1);
1040:
1041: CURSOR l_pal_csr IS
1042: SELECT 'x'
1043: FROM okl_fe_adj_mat_versions
1044: WHERE adj_mat_version_id = p_lrvv_rec.adj_mat_version_id
1045: AND p_lrvv_rec.effective_from_date BETWEEN effective_from_date AND nvl(effective_to_date, p_lrvv_rec.effective_from_date + 1);
1046: l_dummy_var varchar2(1) := '?';
1047: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 1127: ,p_token3_value => 'OKL_FE_ADJ_MAT_VERSIONS');

1123: ,p_token1_value => 'PAM_VERSION_ID'
1124: ,p_token2 => g_child_table_token
1125: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'
1126: ,p_token3 => g_parent_table_token
1127: ,p_token3_value => 'OKL_FE_ADJ_MAT_VERSIONS');
1128: RAISE okl_api.g_exception_error;
1129: END IF;
1130: END IF;
1131: