269:
270: /* Commented the following cursor and modified as below for bug# 3732090
271: CURSOR getApprover IS
272: select wp_approver_source_id, wp_approver_source_type
273: from pa_proj_workplan_attr
274: where project_id = l_project_id; */
275:
276: CURSOR getApprover IS
277: select wp.wp_approver_source_id, wp.wp_approver_source_type, p1.full_name
274: where project_id = l_project_id; */
275:
276: CURSOR getApprover IS
277: select wp.wp_approver_source_id, wp.wp_approver_source_type, p1.full_name
278: from pa_proj_workplan_attr wp, per_all_people_f p1
279: where wp.project_id = l_project_id
280: and p1.person_id = wp.wp_approver_source_id
281: and trunc(sysdate) between trunc(p1.effective_start_date)
282: and NVL(p1.effective_end_date, sysdate);