APPS.PA_TASK_APPROVAL_PKG dependencies on PA_PROJ_ELEMENTS

Line 79: FROM PA_PROJ_ELEMENTS

75: WHERE project_id = p_project_id
76: AND task_id = p_parent_task_id
77: AND EXISTS (
78: SELECT 1
79: FROM PA_PROJ_ELEMENTS
80: WHERE proj_element_id = p_parent_task_id
81: AND link_task_flag = 'N');
82:
83: -- Cursor to find out if p_parent_task_id is root/top task

Line 157: update pa_proj_elements

153: 'Parent Task Structure version id ['||p_parent_struc_ver||'], '||
154: 'Approver User Id ['||p_approver_user_id||']'
155: ,3);
156:
157: update pa_proj_elements
158: set task_approver_id = p_approver_user_id
159: where proj_element_id = p_task_id;
160:
161: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (

Line 194: from pa_proj_elements ppe,

190: pa_resource_assignments pra where
191: budget_version_id in (
192: select budget_version_id from pa_budget_versions where ci_id = p_ci_id )
193: and exists (select 1
194: from pa_proj_elements ppe,
195: pa_proj_element_versions ppev,
196: pa_object_relationships por
197: where ppe.proj_element_id = pra.task_id
198: and ppe.project_id = pra.project_id