APPS.GHR_SS_VIEWS_PKG dependencies on FND_ID_FLEX_STRUCTURES_TL

Line 6: g_perf_flex_num fnd_id_flex_structures_tl.id_flex_num%type;

2: /* $Header: ghssview.pkb 120.15.12020000.2 2012/09/05 10:58:08 vmididho ship $ */
3: --
4: -- This is global variable to store flex number for performance SIT .
5: -- This variable is used as cache.
6: g_perf_flex_num fnd_id_flex_structures_tl.id_flex_num%type;
7:
8: --
9: -- This function returns best fit history id for person Extra Info type record on a given a day.
10:

Line 227: from fnd_id_flex_structures_tl flx

223: -- From the second time it uses the flex number stored in cache.
224:
225: cursor get_flex_num is
226: select flx.id_flex_num id_flex_num
227: from fnd_id_flex_structures_tl flx
228: where flx.id_flex_code = 'PEA' and
229: flx.application_id = 800 and
230: flx.id_flex_structure_name = 'US Fed Perf Appraisal' and
231: flx.language = 'US' ;

Line 648: from fnd_id_flex_structures_tl flx

644: -- From the second time it uses the flex number stored in cache.
645:
646: cursor get_flex_num is
647: select flx.id_flex_num id_flex_num
648: from fnd_id_flex_structures_tl flx
649: where flx.id_flex_code = 'PEA' and flx.application_id = 800 and
650: flx.id_flex_structure_name = 'US Fed Perf Appraisal' and
651: flx.language = 'US';
652: