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';
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';