38: select outer.effort_report_id, outer.person_id, ppf.full_name,
39: -- people.full_name approver_name,
40: pert.begin_date, pert.End_date, pbg.name
41: from psp_effort_reports outer,
42: psp_effort_report_templates pert ,
43: per_all_people_f ppf,
44: -- wf_notifications wfis,
45: per_business_groups pbg
46: -- ,
90: select effort_report_id, outer.person_id, ppf.full_name ,
91: -- people.full_name approver_name,
92: pert.begin_date, pert.end_date , pal.adjustment_batch_name, pbg.name
93: from psp_effort_reports outer,
94: psp_effort_report_templates pert,
95: per_all_people_f ppf,
96: ----wf_notifications wfis,
97: psp_adjustment_control_table pal,
98: per_business_groups pbg
154: select effort_report_id, outer.person_id, ppf.full_name ,
155: -- people.full_name approver_name,
156: pert.begin_date, pert.end_date, pal.adjustment_batch_name, pbg.name
157: from psp_effort_reports outer,
158: psp_effort_report_templates pert,
159: per_all_people_f ppf,
160: ----wf_notifications wfis,
161: psp_adjustment_control_table pal,
162: psp_payroll_controls ppc,