APPS.GHR_API dependencies on FND_ID_FLEX_STRUCTURES

Line 3641: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

3637: ,p_special_info OUT NOCOPY ghr_api.special_information_type
3638: )
3639: is
3640: l_proc varchar2(72) := 'return_special_information ';
3641: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3642: l_max_segment per_analysis_criteria.segment1%type;
3643:
3644: Cursor c_flex_num is
3645: select flx.id_flex_num

Line 3646: from fnd_id_flex_structures_tl flx

3642: l_max_segment per_analysis_criteria.segment1%type;
3643:
3644: Cursor c_flex_num is
3645: select flx.id_flex_num
3646: from fnd_id_flex_structures_tl flx
3647: where flx.id_flex_code = 'PEA' --
3648: and flx.application_id = 800 --
3649: and flx.id_flex_structure_name = p_structure_name
3650: and flx.language = 'US';

Line 3772: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

3768: is
3769:
3770: l_proc varchar2(72) := 'return_education_Details';
3771: l_special_info ghr_api.special_information_type;
3772: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3773:
3774: Cursor c_flex_num is
3775: select flx.id_flex_num
3776: from fnd_id_flex_structures_tl flx

Line 3776: from fnd_id_flex_structures_tl flx

3772: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3773:
3774: Cursor c_flex_num is
3775: select flx.id_flex_num
3776: from fnd_id_flex_structures_tl flx
3777: where flx.id_flex_code = 'PEA' --
3778: and flx.application_id = 800 --
3779: and flx.id_flex_structure_name = 'US Fed Education'
3780: and flx.language = 'US';