APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on PA_PROJECTS_ALL

Line 81: from pa_projects_all a

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

Line 1016: pa_projects_all pa

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 ;
1020: