DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 212: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

208:
209: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
210: IS
211: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
212: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
213: where str.element_version_id = c_structure_version_id
214: AND str.project_id = c_project_id
215: AND str.status_code = status.project_status_code;
216: