DBA Data[Home] [Help]

APPS.GHR_BREAKDOWN_RPT dependencies on FND_ID_FLEX_STRUCTURES

Line 207: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

203: ,p_special_info OUT NOCOPY ghr_api.special_information_type
204: )
205: is
206: l_proc varchar2(72) := 'return_special_information ';
207: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
208: l_max_segment per_analysis_criteria.segment1%type;
209:
210: Cursor c_flex_num is
211: select flx.id_flex_num

Line 212: from fnd_id_flex_structures_tl flx

208: l_max_segment per_analysis_criteria.segment1%type;
209:
210: Cursor c_flex_num is
211: select flx.id_flex_num
212: from fnd_id_flex_structures_tl flx
213: where flx.id_flex_code = 'PEA' --
214: and flx.application_id = 800 --
215: and flx.id_flex_structure_name = p_structure_name
216: and flx.language = 'US';