APPS.PAY_JP_DBI_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 4: g_elm_name pay_element_types_f.element_name%type;

1: package body pay_jp_dbi_pkg as
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: --

Line 5: g_elm_name_tl pay_element_types_f_tl.element_name%type;

1: package body pay_jp_dbi_pkg as
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

Line 152: l_elm_tl pay_element_types_f_tl.element_name%type;

148: p_element_name in varchar2)
149: return varchar2
150: is
151: --
152: l_elm_tl pay_element_types_f_tl.element_name%type;
153: --
154: cursor csr_elm_tl
155: is
156: select petl.element_name

Line 157: from pay_element_types_f_tl petl,

153: --
154: cursor csr_elm_tl
155: is
156: select petl.element_name
157: from pay_element_types_f_tl petl,
158: pay_element_types_f pet
159: where pet.element_name = p_element_name
160: and pet.legislation_code = 'JP'
161: and petl.element_type_id = pet.element_type_id

Line 158: pay_element_types_f pet

154: cursor csr_elm_tl
155: is
156: select petl.element_name
157: from pay_element_types_f_tl petl,
158: pay_element_types_f pet
159: where pet.element_name = p_element_name
160: and pet.legislation_code = 'JP'
161: and petl.element_type_id = pet.element_type_id
162: and petl.language = 'JA';