APPS.PAY_JP_ITAX_REPORT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 115: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);

111: D66 varchar2(240),
112: D67 varchar2(240),
113: D68 varchar2(240),
114: D69 varchar2(240),
115: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
116: type t_tbl is table of t_rec index by binary_integer;
117: g_tbl t_tbl;
118: -- |---------------------------------------------------------------------------|
119: -- |---------------------------------< init >----------------------------------|

Line 343: append_from_clause(', hr_assignment_set_amendments amd');

339: hr_jp_ast_utility_pkg.get_assignment_set_info(p_assignment_set_id, l_formula_id, l_amendment_type);
340: --
341: if l_amendment_type <> 'N' then
342: append_select_clause(', amd.include_or_exclude');
343: append_from_clause(', hr_assignment_set_amendments amd');
344: --
345: if l_formula_id is null and l_amendment_type <> 'E' then
346: append_where_clause(
347: 'amd.assignment_set_id = ' || p_assignment_set_id || '