APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_FE_CRITERIA

Line 83: FROM okl_fe_criteria_set ech

79: and version_number= p_ver_number-1;
80:
81: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
82: SELECT max(effective_from_date)
83: FROM okl_fe_criteria_set ech
84: ,okl_fe_criteria ecl
85: WHERE ecl.criteria_set_id = ech.criteria_set_id
86: AND ech.source_id = p_version_id AND source_object_code = 'PAM';
87:

Line 84: ,okl_fe_criteria ecl

80:
81: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
82: SELECT max(effective_from_date)
83: FROM okl_fe_criteria_set ech
84: ,okl_fe_criteria ecl
85: WHERE ecl.criteria_set_id = ech.criteria_set_id
86: AND ech.source_id = p_version_id AND source_object_code = 'PAM';
87:
88: BEGIN

Line 326: FROM OKL_FE_CRITERIA_SET WHERE SOURCE_ID= p_source_id AND SOURCE_OBJECT_CODE= p_source_object;

322: CREATION_DATE,
323: LAST_UPDATED_BY,
324: LAST_UPDATE_DATE,
325: LAST_UPDATE_LOGIN
326: FROM OKL_FE_CRITERIA_SET WHERE SOURCE_ID= p_source_id AND SOURCE_OBJECT_CODE= p_source_object;
327:
328: -- cursor to fetch the adjustment categories lines record
329: CURSOR adj_cat_lines(p_criteria_set_id IN NUMBER) IS
330: SELECT CRITERIA_ID,

Line 342: FROM OKL_FE_CRITERIA WHERE CRITERIA_SET_ID= p_criteria_set_id;

338: CREATION_DATE,
339: LAST_UPDATED_BY,
340: LAST_UPDATE_DATE,
341: LAST_UPDATE_LOGIN
342: FROM OKL_FE_CRITERIA WHERE CRITERIA_SET_ID= p_criteria_set_id;
343:
344: -- cursor to fetch the adjustment categories values record
345: CURSOR adj_cat_values(p_criteria_id IN NUMBER) IS
346: SELECT CRITERION_VALUE_ID,

Line 1054: FROM okl_fe_criteria_set ech

1050: WHERE adj_mat_id= l_adj_mat_id AND version_number=l_version_number -1;
1051:
1052: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
1053: SELECT max(effective_from_date)
1054: FROM okl_fe_criteria_set ech
1055: ,okl_fe_criteria ecl
1056: WHERE ecl.criteria_set_id = ech.criteria_set_id
1057: AND ech.source_id = p_version_id AND source_object_code = 'PAM';
1058: BEGIN

Line 1055: ,okl_fe_criteria ecl

1051:
1052: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
1053: SELECT max(effective_from_date)
1054: FROM okl_fe_criteria_set ech
1055: ,okl_fe_criteria ecl
1056: WHERE ecl.criteria_set_id = ech.criteria_set_id
1057: AND ech.source_id = p_version_id AND source_object_code = 'PAM';
1058: BEGIN
1059: l_return_status := OKL_API.START_ACTIVITY(l_api_name,