APPS.PAY_MX_PTU_CALC dependencies on HR_ASSIGNMENT_SETS

Line 349: FROM hr_assignment_sets has,

345: WHERE hasa.assignment_set_id = ' || ln_asg_set_id || '
346: AND hasa.include_or_exclude = ''I'')
347: OR EXISTS
348: (SELECT ''x''
349: FROM hr_assignment_sets has,
350: hr_assignment_set_amendments hasa,
351: per_assignments_f paf_all
352: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
353: AND has.assignment_set_id = hasa.assignment_set_id

Line 360: FROM hr_assignment_sets has,

356: AND hasa.include_or_exclude = ''I'')
357: )
358: AND NOT EXISTS
359: (SELECT ''x''
360: FROM hr_assignment_sets has,
361: hr_assignment_set_amendments hasa,
362: per_assignments_f paf_all
363: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
364: AND has.assignment_set_id = hasa.assignment_set_id

Line 422: FROM hr_assignment_sets has,

418: WHERE hasa.assignment_set_id = cp_asg_set_id
419: AND hasa.include_or_exclude = 'I')
420: AND NOT EXISTS
421: (SELECT 'x'
422: FROM hr_assignment_sets has,
423: hr_assignment_set_amendments hasa,
424: per_assignments_f paf_all
425: WHERE has.assignment_set_id = cp_asg_set_id
426: AND has.assignment_set_id = hasa.assignment_set_id

Line 432: FROM hr_assignment_sets has,

428: AND paf_all.person_id = cp_person_id
429: AND hasa.include_or_exclude = 'I')
430: )
431: OR EXISTS (SELECT 'x'
432: FROM hr_assignment_sets has,
433: hr_assignment_set_amendments hasa,
434: per_assignments_f paf_all
435: WHERE has.assignment_set_id = cp_asg_set_id
436: AND has.assignment_set_id = hasa.assignment_set_id