DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_REPORT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 120: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);

116: D73 varchar2(240),
117: D74 varchar2(240),
118: D75 varchar2(240),
119: D76 varchar2(240),
120: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
121: type t_tbl is table of t_rec index by binary_integer;
122: g_tbl t_tbl;
123: -- |---------------------------------------------------------------------------|
124: -- |---------------------------------< init >----------------------------------|

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

351: hr_jp_ast_utility_pkg.get_assignment_set_info(p_assignment_set_id, l_formula_id, l_amendment_type);
352: --
353: if l_amendment_type <> 'N' then
354: append_select_clause(', amd.include_or_exclude');
355: append_from_clause(', hr_assignment_set_amendments amd');
356: --
357: if l_formula_id is null and l_amendment_type <> 'E' then
358: append_where_clause(
359: 'amd.assignment_set_id = ' || p_assignment_set_id || '