APPS.PA_TASK_PUB1 dependencies on PA_TASK_TYPES

Line 8824: pa_task_types ptt

8820: FROM pa_proj_elem_ver_schedule ppevs,
8821: pa_object_relationships por,
8822: pa_proj_element_versions ppev,
8823: pa_proj_elements ppe,
8824: pa_task_types ptt
8825: WHERE por.object_id_from1 = c_parent_element_version_id
8826: AND por.object_type_to = 'PA_TASKS'
8827: AND por.relationship_type = 'S'
8828: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 8856: FROM pa_task_types ptt,

8852:
8853: CURSOR check_progress_allowed(c_element_version_id NUMBER)
8854: IS
8855: SELECT ptt.prog_entry_enable_flag, ppe.project_id /* for bug 2822963 */
8856: FROM pa_task_types ptt,
8857: pa_proj_element_versions ppev,
8858: pa_proj_elements ppe
8859: WHERE ppev.element_version_id = c_element_version_id
8860: AND ppev.proj_element_id = ppe.proj_element_id

Line 8879: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt

8875: -- on all the child tasks equally.
8876: CURSOR get_progressible_child_count(c_parent_element_version_id NUMBER)
8877: IS
8878: SELECT count(rel.object_id_to1)
8879: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt
8880: WHERE rel.object_id_from1 = c_parent_element_version_id
8881: AND rel.object_type_to = 'PA_TASKS'
8882: AND rel.relationship_type = 'S'
8883: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9518: FROM pa_task_types ptt

9514: );
9515:
9516: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
9517: SELECT ptt.prog_entry_enable_flag
9518: FROM pa_task_types ptt
9519: , pa_proj_element_versions ppev,
9520: pa_proj_elements ppe
9521: WHERE ppev.element_version_id = c_element_version_id
9522: AND ppev.proj_element_id = ppe.proj_element_id

Line 11003: FROM pa_task_types ptt

10999: );
11000:
11001: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
11002: SELECT ptt.prog_entry_enable_flag
11003: FROM pa_task_types ptt
11004: , pa_proj_element_versions ppev,
11005: pa_proj_elements ppe
11006: WHERE ppev.element_version_id = c_element_version_id
11007: AND ppev.proj_element_id = ppe.proj_element_id

Line 13900: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev

13896: -- Start modifications for Bug # 3879658.
13897:
13898: cursor cur_progress_status is
13899: select ptt.initial_progress_status_code
13900: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev
13901: where ppev.project_id = ppe.project_id
13902: and ppev.proj_element_id = ppe.proj_element_id
13903: and ppe.type_id = ptt.task_type_id
13904: and ppe.project_id = p_project_id

Line 13925: ,pa_task_types ptt

13921: CURSOR cur_proj_elements(c_proj_element_id NUMBER)
13922: IS
13923: SELECT decode( ppe.base_percent_comp_deriv_code, null, ptt.base_percent_comp_deriv_code, '^', ptt.base_percent_comp_deriv_code, ppe.base_percent_comp_deriv_code )
13924: from pa_proj_elements ppe
13925: ,pa_task_types ptt
13926: where ppe.project_id = p_project_id
13927: and ppe.proj_element_id = c_proj_element_id
13928: and ppe.type_id = ptt.task_type_id;
13929: