DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 204: FROM hr_assignment_set_amendments hr_asg

200: and pad.PRIMARY_FLAG ='Y')
201: )
202: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
203: OR EXISTS ( SELECT ''
204: FROM hr_assignment_set_amendments hr_asg
205: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
206: AND hr_asg.assignment_id = asg.assignment_id
207: ))
208: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL

Line 286: FROM hr_assignment_set_amendments hr_asg

282: AND ppt1.payment_type_id= opm1.payment_type_id
283: AND ppt1.category in ('MT')))
284: AND (to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID')) IS NULL
285: OR EXISTS ( SELECT ''
286: FROM hr_assignment_set_amendments hr_asg
287: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
288: AND hr_asg.assignment_id = asg.assignment_id
289: ))
290: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL