351: WHERE hasa.assignment_set_id = ' || ln_asg_set_id || '
352: AND hasa.include_or_exclude = ''I'')
353: OR EXISTS
354: (SELECT ''x''
355: FROM hr_assignment_sets has,
356: hr_assignment_set_amendments hasa,
357: per_assignments_f paf_all
358: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
359: AND has.assignment_set_id = hasa.assignment_set_id
362: AND hasa.include_or_exclude = ''I'')
363: )
364: AND NOT EXISTS
365: (SELECT ''x''
366: FROM hr_assignment_sets has,
367: hr_assignment_set_amendments hasa,
368: per_assignments_f paf_all
369: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
370: AND has.assignment_set_id = hasa.assignment_set_id
424: WHERE hasa.assignment_set_id = cp_asg_set_id
425: AND hasa.include_or_exclude = 'I')
426: AND NOT EXISTS
427: (SELECT 'x'
428: FROM hr_assignment_sets has,
429: hr_assignment_set_amendments hasa,
430: per_assignments_f paf_all
431: WHERE has.assignment_set_id = cp_asg_set_id
432: AND has.assignment_set_id = hasa.assignment_set_id
434: AND paf_all.person_id = cp_person_id
435: AND hasa.include_or_exclude = 'I')
436: )
437: OR EXISTS (SELECT 'x'
438: FROM hr_assignment_sets has,
439: hr_assignment_set_amendments hasa,
440: per_assignments_f paf_all
441: WHERE has.assignment_set_id = cp_asg_set_id
442: AND has.assignment_set_id = hasa.assignment_set_id