DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PVT dependencies on PA_TASK_TYPES

Line 3242: ,pa_task_types ptt

3238: FROM DUAL
3239: WHERE EXISTS (SELECT 'Y'
3240: FROM pa_proj_elements ppe
3241: ,pa_object_relationships obj1
3242: ,pa_task_types ptt
3243: WHERE obj1.object_id_from2 = p_task_element_id
3244: AND obj1.relationship_type = 'A'
3245: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
3246: AND obj1.object_type_from = 'PA_TASKS'

Line 3476: ,pa_task_types ptt

3472: WHERE EXISTS(
3473: SELECT 'Y'
3474: FROM pa_proj_elements ppe
3475: ,pa_object_relationships obj1
3476: ,pa_task_types ptt
3477: WHERE
3478: ppe.project_id = c_project_id
3479: and ppe.object_type = 'PA_TASKS'
3480: and ppe.type_id = ptt.task_type_id

Line 3724: ,pa_task_types ptt

3720: ,ptt.initial_status_code -- Bug#3515852
3721: FROM pa_proj_elements ppe
3722: ,pa_proj_elem_ver_schedule pvs
3723: ,pa_proj_element_versions pev
3724: ,pa_task_types ptt
3725: WHERE ppe.proj_element_id = c_proj_element_id
3726: AND ppe.object_type = 'PA_DELIVERABLES'
3727: AND pev.proj_element_id = c_proj_element_id
3728: AND pev.object_type = 'PA_DELIVERABLES'

Line 3771: ,pa_task_types ptt

3767: ,ptt.initial_status_code -- Bug#3515852
3768: FROM pa_proj_elements ppe
3769: ,pa_proj_elem_ver_schedule pvs
3770: ,pa_proj_element_versions pev
3771: ,pa_task_types ptt
3772: WHERE ppe.project_id = p_source_project_id
3773: AND ppe.object_type = 'PA_DELIVERABLES'
3774: AND pev.proj_element_id = ppe.proj_element_id
3775: AND pev.project_id = p_source_project_id