APPS.GHR_HISTORY_FETCH dependencies on PER_ANALYSIS_CRITERIA

Line 3011: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;

3007: )
3008: is
3009: l_proc varchar2(72) := 'return_special_information ';
3010: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3011: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
3012: l_session ghr_history_api.g_session_var_type;
3013: l_person_analysis_id per_person_analyses.person_analysis_id%type;
3014: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3015:

Line 3086: from per_analysis_Criteria pea

3082: pea.segment27,
3083: pea.segment28,
3084: pea.segment29,
3085: pea.segment30
3086: from per_analysis_Criteria pea
3087: where pea.analysis_Criteria_id = l_analysis_criteria_id
3088: and p_effective_date
3089: between nvl(pea.start_date_active,p_effective_date)
3090: and nvl(pea.end_date_active,p_effective_date);