APPS.PA_STATUS_PUB dependencies on PA_PROJ_ELEMENTS

Line 150: FROM pa_proj_elements ppe,

146: and pst.structure_type_class_code = c_structure_type;
147:
148: CURSOR c_get_del_associated_task(c_project_id NUMBER, c_del_proj_element_id NUMBER, c_object_type VARCHAR2) IS
149: SELECT ppe.proj_element_id --, por.object_id_to1 (commented by rtarway for BUG 3746647)
150: FROM pa_proj_elements ppe,
151: pa_object_relationships por
152: WHERE
153: ppe.object_type = 'PA_TASKS'
154: and ppe.proj_element_id = por.object_id_from2

Line 1941: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).LOWEST_LEVEL_TASK := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_OBJECT_VERSION_ID);

1937: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).ACTUAL_EFFORT_TO_DATE := l_ACTUAL_EFFORT_TO_DATE;
1938:
1939: IF G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).OBJECT_TYPE = 'PA_TASKS'
1940: THEN
1941: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).LOWEST_LEVEL_TASK := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_OBJECT_VERSION_ID);
1942: ELSE
1943: G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).LOWEST_LEVEL_TASK := 'N';
1944: END IF;
1945:

Line 2733: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_OBJECT_VERSION_ID);

2729: /* Bug 3606627
2730: if l_progress_mode <> 'BACKDATED' then
2731: IF l_object_type = 'PA_TASKS'
2732: THEN
2733: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => l_OBJECT_VERSION_ID);
2734: ELSE
2735: l_lowest_level_task := 'N';
2736: END IF;
2737: