APPS.PA_TASK_PUB1 dependencies on PA_TASK_TYPES

Line 8461: pa_task_types ptt

8457: FROM pa_proj_elem_ver_schedule ppevs,
8458: pa_object_relationships por,
8459: pa_proj_element_versions ppev,
8460: pa_proj_elements ppe,
8461: pa_task_types ptt
8462: WHERE por.object_id_from1 = c_parent_element_version_id
8463: AND por.object_type_to = 'PA_TASKS'
8464: AND por.relationship_type = 'S'
8465: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 8493: FROM pa_task_types ptt,

8489:
8490: CURSOR check_progress_allowed(c_element_version_id NUMBER)
8491: IS
8492: SELECT ptt.prog_entry_enable_flag, ppe.project_id /* for bug 2822963 */
8493: FROM pa_task_types ptt,
8494: pa_proj_element_versions ppev,
8495: pa_proj_elements ppe
8496: WHERE ppev.element_version_id = c_element_version_id
8497: AND ppev.proj_element_id = ppe.proj_element_id

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

8512: -- on all the child tasks equally.
8513: CURSOR get_progressible_child_count(c_parent_element_version_id NUMBER)
8514: IS
8515: SELECT count(rel.object_id_to1)
8516: FROM PA_OBJECT_RELATIONSHIPS rel,pa_proj_element_versions ver,pa_proj_elements ele,pa_task_types tt
8517: WHERE rel.object_id_from1 = c_parent_element_version_id
8518: AND rel.object_type_to = 'PA_TASKS'
8519: AND rel.relationship_type = 'S'
8520: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 9155: FROM pa_task_types ptt

9151: );
9152:
9153: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
9154: SELECT ptt.prog_entry_enable_flag
9155: FROM pa_task_types ptt
9156: , pa_proj_element_versions ppev,
9157: pa_proj_elements ppe
9158: WHERE ppev.element_version_id = c_element_version_id
9159: AND ppev.proj_element_id = ppe.proj_element_id

Line 10623: FROM pa_task_types ptt

10619: );
10620:
10621: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
10622: SELECT ptt.prog_entry_enable_flag
10623: FROM pa_task_types ptt
10624: , pa_proj_element_versions ppev,
10625: pa_proj_elements ppe
10626: WHERE ppev.element_version_id = c_element_version_id
10627: AND ppev.proj_element_id = ppe.proj_element_id

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

13372: -- Start modifications for Bug # 3879658.
13373:
13374: cursor cur_progress_status is
13375: select ptt.initial_progress_status_code
13376: from pa_task_types ptt, pa_proj_elements ppe, pa_proj_element_versions ppev
13377: where ppev.project_id = ppe.project_id
13378: and ppev.proj_element_id = ppe.proj_element_id
13379: and ppe.type_id = ptt.task_type_id
13380: and ppe.project_id = p_project_id

Line 13401: ,pa_task_types ptt

13397: CURSOR cur_proj_elements(c_proj_element_id NUMBER)
13398: IS
13399: 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 )
13400: from pa_proj_elements ppe
13401: ,pa_task_types ptt
13402: where ppe.project_id = p_project_id
13403: and ppe.proj_element_id = c_proj_element_id
13404: and ppe.type_id = ptt.task_type_id;
13405: