APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_PROJ_ELEMENTS

Line 51: FROM PA_PROJ_ELEMENTS PPE,

47: ppe1.element_number parent_task_number,
48: ppe1.proj_element_id parent_task_id,
49: ppe1.name parent_task_name,
50: ppev1.wbs_level parent_task_wbs_level
51: FROM PA_PROJ_ELEMENTS PPE,
52: PA_PROJ_ELEMENT_VERSIONS ppev,
53: PA_PROJ_ELEM_VER_SCHEDULE ppevs,
54: PA_PROJ_ELEMENTS PPE1,
55: PA_PROJ_ELEMENT_VERSIONS ppev1,

Line 54: PA_PROJ_ELEMENTS PPE1,

50: ppev1.wbs_level parent_task_wbs_level
51: FROM PA_PROJ_ELEMENTS PPE,
52: PA_PROJ_ELEMENT_VERSIONS ppev,
53: PA_PROJ_ELEM_VER_SCHEDULE ppevs,
54: PA_PROJ_ELEMENTS PPE1,
55: PA_PROJ_ELEMENT_VERSIONS ppev1,
56: PA_OBJECT_RELATIONSHIPS por,
57: PA_PROJECTS_ALL ppa
58: WHERE ppa.project_id = p_project_id

Line 206: -- This procedure marks task as 'Pending' for its parent task approval in pa_proj_elements.

202: ,resultout OUT NOCOPY VARCHAR2);
203:
204: /*---------------------------------------------------------------------------------------------------------
205: -- This method is invoked from Task workflow if the parent task of the submitted task is not yet approved.
206: -- This procedure marks task as 'Pending' for its parent task approval in pa_proj_elements.
207: -- Input parameters
208: -- Parameters Type Required Description
209: -- itemtype VARCHAR2 YES Workflow Item type
210: -- itemkey VARCHAR2 YES Item Key -> Unique identifier of the run