169: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
170: BETWEEN SS.effective_start_date and SS.effective_end_date
171: AND pay_magtape_generic.date_earned(PA.effective_date,AA.assignment_id)
172: BETWEEN PE.effective_start_date and PE.effective_end_date
173: AND exists (select 'x' from pay_action_interlocks pai,
174: pay_assignment_actions paa1,
175: pay_payroll_actions ppa1
176: where paa1.assignment_action_id = AA.assignment_action_id
177: and paa1.assignment_action_id = pai.locking_action_id