APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 3339: from pa_proj_elements a, pa_proj_structure_types b, pa_structure_types c

3335: l_check_sharing_enabled := PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id);
3336:
3337: /* hsiu: added, 3305199 */
3338: select a.proj_element_id into l_parent_structure_id
3339: from pa_proj_elements a, pa_proj_structure_types b, pa_structure_types c
3340: where a.proj_element_id = b.proj_element_id
3341: and a.project_id = p_project_id
3342: and b.structure_type_id = c.structure_type_id
3343: and c.structure_type = 'FINANCIAL';

Line 3390: SELECT B.PROJ_ELEMENT_ID INTO l_proj_element_id FROM PA_PROJECTS_ALL A,PA_PROJ_STRUCTURE_TYPES B,PA_PROJ_ELEMENTS C

3386: x_msg_data => l_msg_data,
3387: x_return_status => l_return_status);
3388:
3389: /* hsiu: 3305199
3390: SELECT B.PROJ_ELEMENT_ID INTO l_proj_element_id FROM PA_PROJECTS_ALL A,PA_PROJ_STRUCTURE_TYPES B,PA_PROJ_ELEMENTS C
3391: WHERE A.PROJECT_ID = C.PROJECT_ID
3392: AND B.PROJ_ELEMENT_ID = C.PROJ_ELEMENT_ID
3393: AND B.PROJ_STRUCTURE_TYPE_ID = 6
3394: AND A.PROJECT_ID = P_PROJECT_ID;

Line 3422: FROM pa_proj_structure_types

3418:
3419: PA_PROJ_PROGRESS_ATTR_PKG.delete_row(l_rowid);
3420:
3421: SELECT rowid into l_rowid
3422: FROM pa_proj_structure_types
3423: WHERE proj_element_id = l_parent_structure_id
3424: and STRUCTURE_TYPE_ID = 6;
3425:
3426: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

Line 3426: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

3422: FROM pa_proj_structure_types
3423: WHERE proj_element_id = l_parent_structure_id
3424: and STRUCTURE_TYPE_ID = 6;
3425:
3426: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
3427:
3428: IF (l_check_sharing_enabled <> 'Y') THEN
3429:
3430: select record_version_number