DBA Data[Home] [Help]

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