APPS.GHR_CPDF_EHRIS dependencies on FND_ID_FLEX_STRUCTURES

Line 483: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

479: l_proc varchar2(30) := 'get_from_history_ancrit';
480: l_ANCRIT_REC ghr_api.special_information_type;
481: l_emp_number per_all_people.employee_number%TYPE;
482:
483: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
484: l_max_segment per_analysis_criteria.segment1%type;
485: l_lang_cnt number;
486: l_flex_struct_name varchar2(30);
487: l_special_pay_plan varchar2(30);

Line 501: from fnd_id_flex_structures_tl flx

497: AND per.effective_end_date;
498:
499: Cursor c_flex_num is
500: select flx.id_flex_num
501: from fnd_id_flex_structures_tl flx
502: where flx.id_flex_code = 'PEA' --
503: and flx.application_id = 800 --
504: and flx.id_flex_structure_name = l_flex_struct_name
505: and flx.language = 'US';