APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_TASK_TYPES

Line 7420: from pa_task_types

7416:
7417: --hsiu: bug 2667527
7418: CURSOR get_init_task_stat(c_task_type_id NUMBER) IS
7419: select INITIAL_STATUS_CODE
7420: from pa_task_types
7421: where task_type_id = c_task_type_id;
7422: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;
7423: --end bug 2667527
7424: BEGIN

Line 7422: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;

7418: CURSOR get_init_task_stat(c_task_type_id NUMBER) IS
7419: select INITIAL_STATUS_CODE
7420: from pa_task_types
7421: where task_type_id = c_task_type_id;
7422: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;
7423: --end bug 2667527
7424: BEGIN
7425: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE');
7426:

Line 13081: FROM pa_task_types ptt

13077: AND object_type = 'PA_TASKS';
13078:
13079: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
13080: SELECT ptt.prog_entry_enable_flag
13081: FROM pa_task_types ptt
13082: , pa_proj_element_versions ppev
13083: , pa_proj_elements ppe
13084: WHERE ppev.element_version_id = c_element_version_id
13085: AND ppev.proj_element_id = ppe.proj_element_id

Line 13103: , pa_task_types ptt

13099: FROM pa_proj_elem_ver_schedule ppevs
13100: , pa_object_relationships por
13101: , pa_proj_element_versions ppev
13102: , pa_proj_elements ppe
13103: , pa_task_types ptt
13104: WHERE por.object_id_from1 = c_parent_element_version_id
13105: AND por.object_type_to = 'PA_TASKS'
13106: AND por.relationship_type = 'S'
13107: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')