DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJ_WORKPLAN_ATTR

Line 273: from pa_proj_workplan_attr

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

Line 278: from pa_proj_workplan_attr wp, per_all_people_f p1

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);