DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 879: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);

875: person_id number,
876: assignment_id number,
877: assignment_action_id number,
878: effective_date date,
879: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type);
880: type t_ass_tbl is table of t_ass_rec index by binary_integer;
881: g_ass_tbl t_ass_tbl;
882: g_ass_ind_tbl t_ass_tbl;
883: --

Line 6734: hr_assignment_set_amendments hasa,

6730: and peev_itax_type2.effective_end_date = pee_itax_type2.effective_end_date
6731: and peev_itax_type2.screen_entry_value <> 'E'
6732: and paa2.assignment_id = paa.assignment_id
6733: and paa2.action_sequence > paa.action_sequence)) larch_v,
6734: hr_assignment_set_amendments hasa,
6735: pay_jp_itwb_assact_v pjia,
6736: pay_assignment_actions paa_o
6737: where to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',
6738: decode(nvl(g_ass_set_amendment_type,'X'),'I',hasa.assignment_id,larch_v.assignment_id),