APPS.GHR_API dependencies on FND_ID_FLEX_STRUCTURES

Line 3648: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

3644: ,p_special_info OUT NOCOPY ghr_api.special_information_type
3645: )
3646: is
3647: l_proc varchar2(72) := 'return_special_information ';
3648: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3649: l_max_segment per_analysis_criteria.segment1%type;
3650:
3651: Cursor c_flex_num is
3652: select flx.id_flex_num

Line 3653: from fnd_id_flex_structures_tl flx

3649: l_max_segment per_analysis_criteria.segment1%type;
3650:
3651: Cursor c_flex_num is
3652: select flx.id_flex_num
3653: from fnd_id_flex_structures_tl flx
3654: where flx.id_flex_code = 'PEA' --
3655: and flx.application_id = 800 --
3656: and flx.id_flex_structure_name = p_structure_name
3657: and flx.language = 'US';

Line 3779: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

3775: is
3776:
3777: l_proc varchar2(72) := 'return_education_Details';
3778: l_special_info ghr_api.special_information_type;
3779: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3780:
3781: Cursor c_flex_num is
3782: select flx.id_flex_num
3783: from fnd_id_flex_structures_tl flx

Line 3783: from fnd_id_flex_structures_tl flx

3779: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
3780:
3781: Cursor c_flex_num is
3782: select flx.id_flex_num
3783: from fnd_id_flex_structures_tl flx
3784: where flx.id_flex_code = 'PEA' --
3785: and flx.application_id = 800 --
3786: and flx.id_flex_structure_name = 'US Fed Education'
3787: and flx.language = 'US';