APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJ_WORKPLAN_ATTR

Line 284: from pa_proj_workplan_attr

280:
281: /* Commented the following cursor and modified as below for bug# 3732090
282: CURSOR getApprover IS
283: select wp_approver_source_id, wp_approver_source_type
284: from pa_proj_workplan_attr
285: where project_id = l_project_id; */
286:
287: CURSOR getApprover IS
288: select wp.wp_approver_source_id, wp.wp_approver_source_type, p1.full_name

Line 289: from pa_proj_workplan_attr wp, per_all_people_f p1

285: where project_id = l_project_id; */
286:
287: CURSOR getApprover IS
288: select wp.wp_approver_source_id, wp.wp_approver_source_type, p1.full_name
289: from pa_proj_workplan_attr wp, per_all_people_f p1
290: where wp.project_id = l_project_id
291: and p1.person_id = wp.wp_approver_source_id
292: and trunc(sysdate) between trunc(p1.effective_start_date)
293: and NVL(p1.effective_end_date, sysdate);