APPS.GHR_RIF_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 14: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

10: ,p_special_info3 out nocopy ghr_api.special_information_type
11: )
12: is
13: l_proc varchar2(72) := 'return_special_information ';
14: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
15:
16: Cursor c_flex_num is
17: select flx.id_flex_num
18: from fnd_id_flex_structures_tl flx

Line 18: from fnd_id_flex_structures_tl flx

14: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
15:
16: Cursor c_flex_num is
17: select flx.id_flex_num
18: from fnd_id_flex_structures_tl flx
19: where flx.id_flex_code = 'PEA' --
20: and flx.application_id = 800 --
21: and flx.id_flex_structure_name = p_structure_name
22: and flx.language = 'US';