APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJ_ELEMENTS

Line 644: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele

640: and f2.function_id = f1.function_id)
641: UNION
642: select distinct fu.user_id, fu.user_name, papf.email_address,
643: papf.full_name person_name
644: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
645: where ele.project_id = l_project_id
646: and ele.MANAGER_PERSON_ID = fu.employee_id
647: and papf.person_id = fu.employee_id
648: and trunc(sysdate) between papf.effective_start_date

Line 678: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele

674: and f2.function_id = f1.function_id)
675: UNION
676: select distinct fu.user_id, fu.user_name, papf.email_address,
677: papf.full_name person_name
678: from fnd_user fu, per_all_people_f papf, pa_proj_elements ele
679: where ele.project_id = l_project_id
680: and ele.MANAGER_PERSON_ID = fu.employee_id
681: and papf.person_id = fu.employee_id
682: and trunc(sysdate) between papf.effective_start_date

Line 1015: FROM pa_proj_elements ppe,

1011: */
1012: CURSOR get_lead_days
1013: IS
1014: SELECT ppe.wf_start_lead_days
1015: FROM pa_proj_elements ppe,
1016: pa_projects_all pa
1017: WHERE pa.segment1=p_project_number --Removed Upper() from both sides for Performance Bug Fix 3961136
1018: AND ppe.element_number = p_task_number --Removed Upper() from both sides for Performance Bug Fix 3961136
1019: AND pa.project_id = ppe.project_id ;