APPS.GHR_HISTORY_FETCH dependencies on PER_ANALYSIS_CRITERIA

Line 2911: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;

2907: )
2908: is
2909: l_proc varchar2(72) := 'return_special_information ';
2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
2911: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
2912: l_session ghr_history_api.g_session_var_type;
2913: l_person_analysis_id per_person_analyses.person_analysis_id%type;
2914: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2915:

Line 2986: from per_analysis_Criteria pea

2982: pea.segment27,
2983: pea.segment28,
2984: pea.segment29,
2985: pea.segment30
2986: from per_analysis_Criteria pea
2987: where pea.analysis_Criteria_id = l_analysis_criteria_id
2988: and p_effective_date
2989: between nvl(pea.start_date_active,p_effective_date)
2990: and nvl(pea.end_date_active,p_effective_date);