DBA Data[Home] [Help]

APPS.PAY_JP_DBI_PKG dependencies on FF_GLOBALS_F

Line 6: g_glb_name ff_globals_f.global_name%type;

2: /* $Header: pyjpdbi.pkb 120.4 2011/05/17 13:00:44 nchinnam ship $ */
3: --
4: g_elm_name pay_element_types_f.element_name%type;
5: g_elm_name_tl pay_element_types_f_tl.element_name%type;
6: g_glb_name ff_globals_f.global_name%type;
7: g_glb_name_tl ff_globals_f_tl.global_name%type;
8: --
9: procedure translate
10: is

Line 7: g_glb_name_tl ff_globals_f_tl.global_name%type;

3: --
4: g_elm_name pay_element_types_f.element_name%type;
5: g_elm_name_tl pay_element_types_f_tl.element_name%type;
6: g_glb_name ff_globals_f.global_name%type;
7: g_glb_name_tl ff_globals_f_tl.global_name%type;
8: --
9: procedure translate
10: is
11: l_upper_limit hr_lookups.meaning%type;

Line 191: l_glb_tl ff_globals_f_tl.global_name%type;

187: p_global_name in varchar2)
188: return varchar2
189: is
190: --
191: l_glb_tl ff_globals_f_tl.global_name%type;
192: --
193: cursor csr_glb_tl
194: is
195: select fgtl.global_name

Line 196: from ff_globals_f_tl fgtl,

192: --
193: cursor csr_glb_tl
194: is
195: select fgtl.global_name
196: from ff_globals_f_tl fgtl,
197: ff_globals_f fg
198: where fg.global_name = p_global_name
199: and fg.legislation_code = 'JP'
200: and fgtl.global_id = fg.global_id

Line 197: ff_globals_f fg

193: cursor csr_glb_tl
194: is
195: select fgtl.global_name
196: from ff_globals_f_tl fgtl,
197: ff_globals_f fg
198: where fg.global_name = p_global_name
199: and fg.legislation_code = 'JP'
200: and fgtl.global_id = fg.global_id
201: and fgtl.language = 'JA';