[Home] [Help]
696: FROM
697: per_all_assignments_f ASG,
698: pay_assignment_actions paa,
699: pay_payroll_actions ppa,
700: pay_population_ranges ppr
701: WHERE ppa.effective_date between l_period_start
702: and l_period_end
703: and ppa.action_type in ('R','Q','V','B','I')
704: and ppa.action_status = 'C'