[Home] [Help]
5281: cursor adj_er_supercede is
5282: Select per.effort_report_id,
5283: per.person_id,
5284: min(pal.summary_line_id) summary_line_id
5285: From psp_adjustment_lines_history pal,
5286: Psp_eff_reports per,
5287: Psp_payroll_controls ppc
5288: Where pal.distribution_date between per.start_date and per.end_date
5289: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)
5468: cursor adj_asg_er_supercede is
5469: Select per.effort_report_id,
5470: per.person_id,
5471: min(pal.summary_line_id) summary_line_id
5472: From psp_adjustment_lines_history pal,
5473: Psp_eff_reports per,
5474: Psp_payroll_controls ppc,
5475: psp_eff_report_details perd
5476: Where pal.distribution_date between per.start_date and per.end_date