336: DISTINCT act.assignment_id assignment_id
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1
344: ,hr_soft_coding_keyflex hsck
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1
344: ,hr_soft_coding_keyflex hsck
345: WHERE ppa.payroll_action_id = p_payroll_action_id
396: SELECT DISTINCT act.assignment_id assignment_id
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1
404: ,hr_soft_coding_keyflex hsck
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1
404: ,hr_soft_coding_keyflex hsck
405: WHERE ppa.payroll_action_id = p_payroll_action_id