[Home] [Help]
180: and pad.PRIMARY_FLAG ='Y')
181: )
182: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
183: OR EXISTS ( SELECT ''
184: FROM hr_assignment_set_amendments hr_asg
185: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
186: AND hr_asg.assignment_id = asg.assignment_id
187: ))
188: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
260: AND ppt1.payment_type_id= opm1.payment_type_id
261: AND ppt1.category in ('MT')))
262: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
263: OR EXISTS ( SELECT ''
264: FROM hr_assignment_set_amendments hr_asg
265: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
266: AND hr_asg.assignment_id = asg.assignment_id
267: ))
268: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL