APPS.PA_PROJECT_STRUCTURE_PUB1 dependencies on PA_PROJ_STRUCTURE_TYPES

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

3355: l_check_sharing_enabled := PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(p_project_id);
3356:
3357: /* hsiu: added, 3305199 */
3358: select a.proj_element_id into l_parent_structure_id
3359: from pa_proj_elements a, pa_proj_structure_types b, pa_structure_types c
3360: where a.proj_element_id = b.proj_element_id
3361: and a.project_id = p_project_id
3362: and b.structure_type_id = c.structure_type_id
3363: and c.structure_type = 'FINANCIAL';

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

3406: x_msg_data => l_msg_data,
3407: x_return_status => l_return_status);
3408:
3409: /* hsiu: 3305199
3410: SELECT B.PROJ_ELEMENT_ID INTO l_proj_element_id FROM PA_PROJECTS_ALL A,PA_PROJ_STRUCTURE_TYPES B,PA_PROJ_ELEMENTS C
3411: WHERE A.PROJECT_ID = C.PROJECT_ID
3412: AND B.PROJ_ELEMENT_ID = C.PROJ_ELEMENT_ID
3413: AND B.PROJ_STRUCTURE_TYPE_ID = 6
3414: AND A.PROJECT_ID = P_PROJECT_ID;

Line 3442: FROM pa_proj_structure_types

3438:
3439: PA_PROJ_PROGRESS_ATTR_PKG.delete_row(l_rowid);
3440:
3441: SELECT rowid into l_rowid
3442: FROM pa_proj_structure_types
3443: WHERE proj_element_id = l_parent_structure_id
3444: and STRUCTURE_TYPE_ID = 6;
3445:
3446: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

Line 3446: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

3442: FROM pa_proj_structure_types
3443: WHERE proj_element_id = l_parent_structure_id
3444: and STRUCTURE_TYPE_ID = 6;
3445:
3446: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
3447:
3448: IF (l_check_sharing_enabled <> 'Y') THEN
3449:
3450: select record_version_number