APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_TASKS

Line 1594: and ci.object_type = 'PA_TASKS'

1590: pa_control_items ci
1591: where
1592: ppe.proj_element_id = ci.object_id
1593: and ppe.project_id = ci.project_id
1594: and ci.object_type = 'PA_TASKS'
1595: and ci_id = p_ci_id ;
1596: -- Bug#12553936 end
1597: Cursor get_owner_role(p_cus_id fnd_user.customer_id%type)
1598: Is

Line 2815: and por.object_type_to = 'PA_TASKS'

2811: and ppe.link_task_flag = 'Y'
2812: and ppe.type_id = 1
2813: and ppev.proj_element_id = ppe.proj_element_id
2814: and por.object_id_to1 = ppev.element_version_id
2815: and por.object_type_to = 'PA_TASKS'
2816: and por.relationship_type = 'S'
2817: and ppev.financial_task_flag = 'Y')
2818: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id)
2819: );

Line 2818: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id)

2814: and por.object_id_to1 = ppev.element_version_id
2815: and por.object_type_to = 'PA_TASKS'
2816: and por.relationship_type = 'S'
2817: and ppev.financial_task_flag = 'Y')
2818: and not exists (select 1 from pa_tasks where task_id = pra.task_id and project_id = pra.project_id)
2819: );
2820:
2821:
2822: l_index1 NUMBER;