DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on FND_ID_FLEX_STRUCTURES

Line 3010: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

3006: ,p_special_info out nocopy ghr_api.special_information_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;

Line 3018: from fnd_id_flex_structures_tl flx

3014: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3015:
3016: Cursor c_flex_num is
3017: select flx.id_flex_num
3018: from fnd_id_flex_structures_tl flx
3019: where flx.id_flex_code = 'PEA' --
3020: and flx.application_id = 800 --
3021: and flx.id_flex_structure_name = p_structure_name
3022: and flx.language = 'US';