APPS.OKL_ECC_VALUES_PVT dependencies on OKL_FE_CRITERION_VALUES

Line 250: FROM okl_fe_criterion_values

246: WHERE criteria_set_id = p_criteria_set_id;
247:
248: CURSOR get_ecv_tbl(p_criteria_id IN number) IS
249: SELECT criterion_value_id
250: FROM okl_fe_criterion_values
251: WHERE criteria_id = p_criteria_id;
252: i number;
253: j number;
254: l_api_name CONSTANT varchar2(30) := 'DELETE_ELIG_CRITERIA';

Line 870: FROM okl_fe_criterion_values

866: l_ecv_rec okl_ecv_rec;
867:
868: CURSOR get_lines_values(p_line_id IN number) IS
869: SELECT criterion_value_id
870: FROM okl_fe_criterion_values
871: WHERE okl_fe_criterion_values.criteria_id = p_line_id;
872: l_api_name CONSTANT varchar2(30) := 'REMOVE_EC_LINE(REC)';
873: l_api_version CONSTANT number := 1.0;
874: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 871: WHERE okl_fe_criterion_values.criteria_id = p_line_id;

867:
868: CURSOR get_lines_values(p_line_id IN number) IS
869: SELECT criterion_value_id
870: FROM okl_fe_criterion_values
871: WHERE okl_fe_criterion_values.criteria_id = p_line_id;
872: l_api_name CONSTANT varchar2(30) := 'REMOVE_EC_LINE(REC)';
873: l_api_version CONSTANT number := 1.0;
874: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
875: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_values_pvt.remove_ec_line';

Line 1037: FROM okl_fe_criterion_values

1033: ,criteria_id
1034: ,operator_code
1035: ,crit_cat_value1
1036: ,crit_cat_value2
1037: FROM okl_fe_criterion_values
1038: WHERE criteria_id = p_criteria_id;
1039: i number;
1040: j number;
1041: l_api_name CONSTANT varchar2(30) := 'GET_ELIG_CRIT_DT';

Line 1241: FROM okl_fe_criterion_values

1237: ,criteria_id
1238: ,operator_code
1239: ,crit_cat_value1
1240: ,crit_cat_value2
1241: FROM okl_fe_criterion_values
1242: WHERE criteria_id = p_criteria_id;
1243: i number;
1244: j number;
1245: l_source_id number;