APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_FE_CRITERIA_SET

Line 193: FROM okl_fe_criteria_set

189: ,creation_date
190: ,last_updated_by
191: ,last_update_date
192: ,last_update_login
193: FROM okl_fe_criteria_set
194: WHERE source_id = p_source_id AND source_object_code = p_source_object;
195:
196: -- cursor to fetch the adjustment categories lines record
197:

Line 752: FROM okl_fe_criteria_set ech

748: WHERE std_rate_tmpl_id = l_srt_id
749: AND version_number = l_version_number - 1;
750: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
751: SELECT max(effective_from_date)
752: FROM okl_fe_criteria_set ech
753: ,okl_fe_criteria ecl
754: WHERE ecl.criteria_set_id = ech.criteria_set_id
755: AND ech.source_id = p_version_id AND source_object_code = 'SRT';
756:

Line 1717: FROM okl_fe_criteria_set ech

1713: WHERE std_rate_tmpl_id = p_srt_id AND version_number = p_ver_number - 1;
1714:
1715: CURSOR get_elig_crit_start_date(p_version_id IN NUMBER) IS
1716: SELECT max(effective_from_date)
1717: FROM okl_fe_criteria_set ech
1718: ,okl_fe_criteria ecl
1719: WHERE ecl.criteria_set_id = ech.criteria_set_id
1720: AND ech.source_id = p_version_id AND source_object_code = 'SRT';
1721: BEGIN