[Home] [Help]
254: select distinct paa.assignment_id assignment_id,
255: to_number(paa.serial_number)
256: from pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_population_ranges ppr
259: where ppa.report_type = 'RL2'
260: and ppa.report_qualifier = 'CAEOYRL2'
261: and ppa.report_category = 'ARCHIVE'
262: and ppa.effective_date = l_year_end
326: select distinct paa.assignment_id assignment_id,
327: to_number(paa.serial_number)
328: from pay_payroll_actions ppa,
329: pay_assignment_actions paa,
330: pay_population_ranges ppr
331: where ppa.report_type = 'RL2'
332: and ppa.report_qualifier = 'CAEOYRL2'
333: and ppa.report_category = 'ARCHIVE'
334: and ppa.effective_date = l_year_end