DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 207: from hr_assignment_set_amendments

203: -- TAR37293; need to find out if assignments in assignment-set are set to Include or Exclude.
204: begin
205: select distinct include_or_exclude
206: into v_incl_sw
207: from hr_assignment_set_amendments
208: where assignment_set_id = asg_set_id;
209: exception
210: when no_data_found then
211: -- TAR37293;default to Include, should not go here though.

Line 232: from hr_assignment_set_amendments

228: inc_flag varchar2(5);
229: begin
230: select include_or_exclude
231: into inc_flag
232: from hr_assignment_set_amendments
233: where assignment_set_id = asg_set_id
234: and assignment_id = asgrec.assignment_id;
235:
236: if inc_flag = 'E' then