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.4.12010000.4 2008/11/03 08:48:51 managarw 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 202: from fnd_id_flex_structures_tl flx

198: -- From the second time it uses the flex number stored in cache.
199:
200: cursor get_flex_num is
201: select flx.id_flex_num id_flex_num
202: from fnd_id_flex_structures_tl flx
203: where flx.id_flex_code = 'PEA' and
204: flx.application_id = 800 and
205: flx.id_flex_structure_name = 'US Fed Perf Appraisal' and
206: flx.language = 'US' ;

Line 623: from fnd_id_flex_structures_tl flx

619: -- From the second time it uses the flex number stored in cache.
620:
621: cursor get_flex_num is
622: select flx.id_flex_num id_flex_num
623: from fnd_id_flex_structures_tl flx
624: where flx.id_flex_code = 'PEA' and flx.application_id = 800 and
625: flx.id_flex_structure_name = 'US Fed Perf Appraisal' and
626: flx.language = 'US';
627: