DBA Data[Home] [Help]

APPS.OKL_ECC_VALUES_PVT dependencies on OKL_FE_CRIT_CAT_DEF_B

Line 26: l_ecc_ac_flag okl_fe_crit_cat_def_b.ecc_ac_flag%TYPE;

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;
30: is_debug_statement_on boolean;

Line 451: FROM okl_fe_crit_cat_def_b

447: CURSOR l_data_type_csr(p_crit_cat_def_id IN number) IS
448: SELECT data_type_code
449: ,value_type_code
450: ,source_yn
451: FROM okl_fe_crit_cat_def_b
452: WHERE crit_cat_def_id = p_crit_cat_def_id;
453: lp_ech_rec okl_ech_rec;
454: lx_ech_rec okl_ech_rec;
455: lp_ecl_tbl okl_ecl_tbl;