APPS.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 17: c_elm_tl pay_element_types_f_tl.element_name%TYPE;

13: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';
14: c_non_res_date_iv_name constant pay_input_values_f.name%TYPE := 'NRES_START_DATE';
15: c_res_date_iv_name constant pay_input_values_f.name%TYPE := 'PROJECTED_RES_DATE';
16: c_elm pay_element_types_f.element_name%TYPE;
17: c_elm_tl pay_element_types_f_tl.element_name%TYPE;
18: c_elm_tl_max number := 30;
19: --
20: -- Global Variables
21: --

Line 57: o_elm_tl pay_element_types_f_tl.element_name%type;

53: p_elm_name in varchar2)
54: return varchar2
55: is
56: --
57: o_elm_tl pay_element_types_f_tl.element_name%type;
58: --
59: -- support only session lang based on case forms and srs session lang is same
60: cursor csr_elm_tl
61: is

Line 65: pay_element_types_f_tl pett

61: is
62: select /*+ ORDERD */
63: pett.element_name
64: from pay_element_types_f pet,
65: pay_element_types_f_tl pett
66: where pet.element_name = p_elm_name
67: and pet.legislation_code = 'JP'
68: and pett.element_type_id = pet.element_type_id
69: and pett.language = userenv('LANG');