DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on FND_ID_FLEX_STRUCTURES

Line 2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

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

Line 2918: from fnd_id_flex_structures_tl flx

2914: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2915:
2916: Cursor c_flex_num is
2917: select flx.id_flex_num
2918: from fnd_id_flex_structures_tl flx
2919: where flx.id_flex_code = 'PEA' --
2920: and flx.application_id = 800 --
2921: and flx.id_flex_structure_name = p_structure_name
2922: and flx.language = 'US';