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
190: -- Bug2856413 To handle payroll in Assgt sets
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
349: -- Bug2856413 To handle payroll in Assgt sets