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