APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_TASK_TYPES

Line 7360: from pa_task_types

7356:
7357: --hsiu: bug 2667527
7358: CURSOR get_init_task_stat(c_task_type_id NUMBER) IS
7359: select INITIAL_STATUS_CODE
7360: from pa_task_types
7361: where task_type_id = c_task_type_id;
7362: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;
7363: --end bug 2667527
7364: BEGIN

Line 7362: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;

7358: CURSOR get_init_task_stat(c_task_type_id NUMBER) IS
7359: select INITIAL_STATUS_CODE
7360: from pa_task_types
7361: where task_type_id = c_task_type_id;
7362: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;
7363: --end bug 2667527
7364: BEGIN
7365: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE');
7366:

Line 12709: FROM pa_task_types ptt

12705: AND object_type = 'PA_TASKS';
12706:
12707: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
12708: SELECT ptt.prog_entry_enable_flag
12709: FROM pa_task_types ptt
12710: , pa_proj_element_versions ppev
12711: , pa_proj_elements ppe
12712: WHERE ppev.element_version_id = c_element_version_id
12713: AND ppev.proj_element_id = ppe.proj_element_id

Line 12731: , pa_task_types ptt

12727: FROM pa_proj_elem_ver_schedule ppevs
12728: , pa_object_relationships por
12729: , pa_proj_element_versions ppev
12730: , pa_proj_elements ppe
12731: , pa_task_types ptt
12732: WHERE por.object_id_from1 = c_parent_element_version_id
12733: AND por.object_type_to = 'PA_TASKS'
12734: AND por.relationship_type = 'S'
12735: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')