181: and pay.payroll_id = NVL(p_payroll_id,pay.payroll_id)
182: and (p_assignment_set_id is null
183: OR exists
184: ( select 1
185: from HR_ASSIGNMENT_SET_AMENDMENTS amend,
186: hr_assignment_sets aset
187: where
188: ( P_ASSIGNMENT_SET_ID IS NOT NULL and
189: aset.assignment_set_id = P_ASSIGNMENT_SET_ID
340: and pay.payroll_id = NVL(p_payroll_id,pay.payroll_id)
341: and (p_assignment_set_id is null
342: OR exists
343: ( select 1
344: from HR_ASSIGNMENT_SET_AMENDMENTS amend,
345: hr_assignment_sets aset
346: where
347: ( P_ASSIGNMENT_SET_ID IS NOT NULL and
348: aset.assignment_set_id = P_ASSIGNMENT_SET_ID