DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_PROJECT_STATUSES

Line 112: from pa_project_statuses

108: p_version_id IN NUMBER ) return VARCHAR2 IS
109:
110: Cursor C is
111: Select project_system_status_code
112: from pa_project_statuses
113: where project_status_code = p_current_rep_status;
114: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;
115:
116: Cursor C1 is

Line 114: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;

110: Cursor C is
111: Select project_system_status_code
112: from pa_project_statuses
113: where project_status_code = p_current_rep_status;
114: l_project_system_status_code pa_project_statuses.project_system_status_code%TYPE;
115:
116: Cursor C1 is
117: Select nvl(approval_required,'N') approval_required
118: -- ,nvl(auto_publish,'N') auto_publish