APPS.PAY_IE_PAYFILE_SEPA dependencies on HR_ASSIGNMENT_SET_AMENDMENTS
Line 121: FROM hr_assignment_set_amendments hr_asg
117: AND ppt.payment_type_name = 'SEPA'
118: AND pap.person_id = NVL(p_person_id,pap.person_id)
119: AND (p_assignment_set_id IS NULL
120: OR EXISTS ( SELECT '' 121: FROM hr_assignment_set_amendments hr_asg 122: WHERE hr_asg.assignment_set_id = p_assignment_set_id
123: AND hr_asg.assignment_id = asg.assignment_id
124: ))
125: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL