56: SELECT
57: paa1.assignment_action_id
58: FROM
59: pay_assignment_actions paa1
60: ,pay_payroll_actions ppa1
61: ,pay_assignment_actions paa2
62: ,pay_payroll_actions ppa2
63: ,pay_action_interlocks pai
64: ,pay_payrolls_f ppf
58: FROM
59: pay_assignment_actions paa1
60: ,pay_payroll_actions ppa1
61: ,pay_assignment_actions paa2
62: ,pay_payroll_actions ppa2
63: ,pay_action_interlocks pai
64: ,pay_payrolls_f ppf
65: WHERE
66: paa1.assignment_id = p_assignment_id