APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJECTS_ALL

Line 84: from pa_projects_all a

80: and b.element_version_id = a.element_version_id;
81:
82: CURSOR getProjectInfo(c_project_id NUMBER) IS
83: select a.name, a.segment1
84: from pa_projects_all a
85: where c_project_id = a.project_id;
86:
87: --Cursor for selecting submitter
88: -- 4586987 customer_id changed to person_party_id

Line 1034: pa_projects_all pa

1030: CURSOR get_lead_days
1031: IS
1032: SELECT ppe.wf_start_lead_days
1033: FROM pa_proj_elements ppe,
1034: pa_projects_all pa
1035: WHERE pa.segment1=p_project_number --Removed Upper() from both sides for Performance Bug Fix 3961136
1036: AND ppe.element_number = p_task_number --Removed Upper() from both sides for Performance Bug Fix 3961136
1037: AND pa.project_id = ppe.project_id ;
1038: