DBA Data[Home] [Help]

APPS.OKL_LRV_PVT dependencies on OKL_FE_EO_TERM_VERS

Line 1031: FROM okl_fe_eo_term_vers

1027: FUNCTION validate_record(p_lrvv_rec IN okl_lrvv_rec) RETURN varchar2 IS
1028:
1029: CURSOR l_pve_csr IS
1030: SELECT 'x'
1031: FROM okl_fe_eo_term_vers
1032: WHERE end_of_term_ver_id = p_lrvv_rec.end_of_term_ver_id
1033: AND p_lrvv_rec.effective_from_date BETWEEN effective_from_date AND nvl(effective_to_date, p_lrvv_rec.effective_from_date + 1);
1034:
1035: CURSOR l_srv_csr IS

Line 1081: ,p_token3_value => 'OKL_FE_EO_TERM_VERS');

1077: ,p_token1_value => 'END_OF_TERM_VER_ID'
1078: ,p_token2 => g_child_table_token
1079: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'
1080: ,p_token3 => g_parent_table_token
1081: ,p_token3_value => 'OKL_FE_EO_TERM_VERS');
1082: RAISE okl_api.g_exception_error;
1083: END IF;
1084: l_dummy_var := '?';
1085: