DBA Data[Home] [Help]

APPS.OKL_ECC_VALUES_PVT dependencies on OKL_FE_CRIT_CAT_DEF_V

Line 19: FROM okl_fe_crit_cat_def_v

15:
16: CURSOR l_crit_cat_name_csr(p_crit_cat_def_id IN number) IS
17: SELECT crit_cat_name
18: ,ecc_ac_flag
19: FROM okl_fe_crit_cat_def_v
20: WHERE crit_cat_def_id = p_crit_cat_def_id;
21: i number;
22: j number;
23: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_effective_dates';

Line 25: l_crit_cat_name okl_fe_crit_cat_def_v.crit_cat_name%TYPE;

21: i number;
22: j number;
23: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'validate_effective_dates';
24: l_crit_cat varchar2(40);
25: l_crit_cat_name okl_fe_crit_cat_def_v.crit_cat_name%TYPE;
26: l_ecc_ac_flag okl_fe_crit_cat_def_b.ecc_ac_flag%TYPE;
27: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.validate_effective_dates';
28: l_debug_enabled varchar2(10);
29: is_debug_procedure_on boolean;