APPS.PAY_AU_TAX_INFO_PKG dependencies on PAY_INPUT_VALUES_F

Line 13: input_value_id pay_input_values_f.input_value_id%type,

9: --
10: c_iv_upper varchar2(1) := 'N';
11: --
12: type t_input_value_id_rec is record(
13: input_value_id pay_input_values_f.input_value_id%type,
14: name pay_input_values_f.name%type);
15: type t_input_value_id_tbl is table of t_input_value_id_rec index by binary_integer;
16: --
17: g_input_value_id_tbl t_input_value_id_tbl;

Line 14: name pay_input_values_f.name%type);

10: c_iv_upper varchar2(1) := 'N';
11: --
12: type t_input_value_id_rec is record(
13: input_value_id pay_input_values_f.input_value_id%type,
14: name pay_input_values_f.name%type);
15: type t_input_value_id_tbl is table of t_input_value_id_rec index by binary_integer;
16: --
17: g_input_value_id_tbl t_input_value_id_tbl;
18: g_tax_info_elm_id number;

Line 67: from pay_input_values_f

63: cursor csr_input_value_id
64: is
65: select input_value_id,
66: decode(c_iv_upper,'Y',upper(name),name) iv_name
67: from pay_input_values_f
68: where element_type_id = p_element_type_id
69: and legislation_code = c_legislation_code;
70: --
71: l_iv_tbl_name pay_input_values_f.name%type;

Line 71: l_iv_tbl_name pay_input_values_f.name%type;

67: from pay_input_values_f
68: where element_type_id = p_element_type_id
69: and legislation_code = c_legislation_code;
70: --
71: l_iv_tbl_name pay_input_values_f.name%type;
72: l_iv_tbl_id pay_input_values_f.input_value_id%type;
73: --
74: l_iv_tbl_cnt number := 0;
75: l_input_value_id number := p_input_value_id;

Line 72: l_iv_tbl_id pay_input_values_f.input_value_id%type;

68: where element_type_id = p_element_type_id
69: and legislation_code = c_legislation_code;
70: --
71: l_iv_tbl_name pay_input_values_f.name%type;
72: l_iv_tbl_id pay_input_values_f.input_value_id%type;
73: --
74: l_iv_tbl_cnt number := 0;
75: l_input_value_id number := p_input_value_id;
76: --