APPS.PA_TASKS_MAINT_PVT dependencies on PA_OBJECT_RELATIONSHIPS

Line 6162: --This cursor gets the immediate parent of the passed task version id from the pa_object_relationships

6158: l_task_exists VARCHAR2(1);
6159: l_user_id NUMBER;
6160: l_login_id NUMBER;
6161: --added for the Bug 14640666
6162: --This cursor gets the immediate parent of the passed task version id from the pa_object_relationships
6163: CURSOR c_get_immediate_parent (l_object_id_to1 NUMBER)
6164: IS
6165: SELECT proj_element_id
6166: FROM pa_proj_element_versions ppev,

Line 6167: pa_object_relationships por

6163: CURSOR c_get_immediate_parent (l_object_id_to1 NUMBER)
6164: IS
6165: SELECT proj_element_id
6166: FROM pa_proj_element_versions ppev,
6167: pa_object_relationships por
6168: WHERE ppev.element_version_id=por.object_id_from1
6169: AND por.relationship_type ='S'
6170: AND por.relationship_subtype ='TASK_TO_TASK'
6171: AND por.object_id_to1 = l_object_id_to1;

Line 6517: , pa_object_relationships obRel

6513: SELECT
6514: elever.proj_element_id
6515: FROM
6516: pa_proj_element_versions elever
6517: , pa_object_relationships obRel
6518: WHERE
6519: obRel.relationship_type ='S'
6520: AND
6521: obRel.relationship_subtype ='TASK_TO_TASK'