DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 5708: From psp_adjustment_lines_history pal,

5704: cursor adj_er_supercede is
5705: Select per.effort_report_id,
5706: per.person_id,
5707: min(pal.summary_line_id) summary_line_id
5708: From psp_adjustment_lines_history pal,
5709: Psp_eff_reports per,
5710: Psp_payroll_controls ppc
5711: Where pal.distribution_date between per.start_date and per.end_date
5712: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5895: From psp_adjustment_lines_history pal,

5891: cursor adj_asg_er_supercede is
5892: Select per.effort_report_id,
5893: per.person_id,
5894: min(pal.summary_line_id) summary_line_id
5895: From psp_adjustment_lines_history pal,
5896: Psp_eff_reports per,
5897: Psp_payroll_controls ppc,
5898: psp_eff_report_details perd
5899: Where pal.distribution_date between per.start_date and per.end_date