APPS.GHR_CPDF_EHRIS dependencies on FND_ID_FLEX_STRUCTURES

Line 470: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

466: l_proc varchar2(30) := 'get_from_history_ancrit';
467: l_ANCRIT_REC ghr_api.special_information_type;
468: l_emp_number per_all_people.employee_number%TYPE;
469:
470: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
471: l_max_segment per_analysis_criteria.segment1%type;
472: l_lang_cnt number;
473: l_flex_struct_name varchar2(30);
474: l_special_pay_plan varchar2(30);

Line 488: from fnd_id_flex_structures_tl flx

484: AND per.effective_end_date;
485:
486: Cursor c_flex_num is
487: select flx.id_flex_num
488: from fnd_id_flex_structures_tl flx
489: where flx.id_flex_code = 'PEA' --
490: and flx.application_id = 800 --
491: and flx.id_flex_structure_name = l_flex_struct_name
492: and flx.language = 'US';