APPS.PAY_IE_PAYPATH_TAPE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS
Line 292: FROM hr_assignment_set_amendments hr_asg
288: AND ppt.payment_type_name = 'PayPath'
289: AND pap.person_id = NVL(p_person_id,pap.person_id)
290: AND (p_assignment_set_id IS NULL
291: OR EXISTS ( SELECT '' 292: FROM hr_assignment_set_amendments hr_asg 293: WHERE hr_asg.assignment_set_id = p_assignment_set_id
294: AND hr_asg.assignment_id = asg.assignment_id
295: ))
296: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL