153: --- AME will be called only for supervisor, i.e min person, min of er_detail_id
154: cursor er_cur_sup_1 is select min(erd.effort_report_detail_id),
155: min(er.person_id),
156: asg.supervisor_id 157: from per_assignments_f asg, 158: psp_eff_reports er,
159: psp_eff_report_details erd
160: where asg.person_id = er.person_id
161: and er.status_code = 'N'
[Home] [Help]