APPS.PAY_JP_ITAX_DPNT_INTERFACE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 7: c_element_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';

3: --
4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_itax_dpnt_interface_pkg.';
7: c_element_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_itax_type_iv_name constant pay_input_values_f.name%TYPE := 'ITX_TYPE';
10: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl

Line 8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';

4: -- Constants
5: --
6: c_package constant varchar2(31) := 'pay_jp_itax_dpnt_interface_pkg.';
7: c_element_name constant pay_element_types_f.element_name%TYPE := 'YEA_DEP_EXM_PROC';
8: c_itax_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_ITX_INFO';
9: c_itax_type_iv_name constant pay_input_values_f.name%TYPE := 'ITX_TYPE';
10: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

Line 13: c_non_res_elm_name constant pay_element_types_f.element_name%TYPE := 'COM_NRES_INFO';

9: c_itax_type_iv_name constant pay_input_values_f.name%TYPE := 'ITX_TYPE';
10: c_non_res_iv_name constant pay_input_values_f.name%TYPE := 'NRES_FLAG';
11: c_value_if_null_tbl constant pay_jp_bee_utility_pkg.t_varchar2_tbl
12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
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;

Line 16: c_elm pay_element_types_f.element_name%TYPE;

12: := pay_jp_bee_utility_pkg.entry_value_tbl('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
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

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 64: from pay_element_types_f pet,

60: cursor csr_elm_tl
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

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');