APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_PROJ_ELEMENTS

Line 1433: l_task_name pa_proj_elements.name%TYPE;

1429: l_role_display_name per_all_people_f.full_name%TYPE; --Added for bug 4049901
1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;
1432: -- Bug#12553936 start
1433: l_task_name pa_proj_elements.name%TYPE;
1434: l_task_number pa_proj_elements.element_number%TYPE;
1435: l_action_process BOOLEAN := true; -- Bug#12703270
1436: l_notify_user VARCHAR2(200) := 'DUMMY'; --Bug#12859815
1437: --Bug#12553936 end

Line 1434: l_task_number pa_proj_elements.element_number%TYPE;

1430: l_role_email_add per_all_people_f.email_address%TYPE; --for bug 8673347
1431: l_content_id NUMBER := 0;
1432: -- Bug#12553936 start
1433: l_task_name pa_proj_elements.name%TYPE;
1434: l_task_number pa_proj_elements.element_number%TYPE;
1435: l_action_process BOOLEAN := true; -- Bug#12703270
1436: l_notify_user VARCHAR2(200) := 'DUMMY'; --Bug#12859815
1437: --Bug#12553936 end
1438: -- This cursor gets the info about the control item.

Line 1589: from pa_proj_elements ppe,

1585: -- Bug#12553936 start
1586: Cursor get_task_info is
1587: select ppe.name,
1588: ppe.element_number
1589: from pa_proj_elements ppe,
1590: pa_control_items ci
1591: where
1592: ppe.proj_element_id = ci.object_id
1593: and ppe.project_id = ci.project_id

Line 2793: from pa_proj_elements ppe,pa_proj_element_versions ppev,

2789: CURSOR c_ci_task_info IS
2790: select ppe.element_number task_number,ppe.name task_name,ppe.description description,
2791: pvsch.scheduled_start_date start_date,pvsch.scheduled_finish_date finish_date,
2792: hz.party_name approver_name
2793: from pa_proj_elements ppe,pa_proj_element_versions ppev,
2794: pa_proj_elem_ver_schedule pvsch,fnd_user fu, hz_parties hz
2795: where ppe.proj_element_id = ppev.proj_element_id
2796: and pvsch.element_version_id = ppev.element_version_id
2797: and ppe.task_approver_id=fu.user_id

Line 2806: from pa_proj_elements ppe,

2802: pa_resource_assignments pra where
2803: budget_version_id in (
2804: select budget_version_id from pa_budget_versions where ci_id =document_id)
2805: and exists (select 1
2806: from pa_proj_elements ppe,
2807: pa_proj_element_versions ppev,
2808: pa_object_relationships por
2809: where ppe.proj_element_id = pra.task_id
2810: and ppe.project_id = pra.project_id