DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_PROJECT_STATUSES

Line 73: FROM pa_projects p, pa_project_statuses ps

69: ,completion_date End_Date
70: ,project_type Project_Type
71: ,carrying_out_organization_id Organization_Id
72: ,ps.project_status_name Project_Status
73: FROM pa_projects p, pa_project_statuses ps
74: WHERE segment1 = p_project_num
75: and ps.project_status_code = p.project_status_code
76: and ps.status_type = 'PROJECT';
77: