APPS.PA_TASKS_MAINT_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 2527: pa_object_relationships

2523: (--Get the Parents of the passed task
2524: SELECT
2525: object_id_from1 object_id
2526: FROM
2527: pa_object_relationships
2528: WHERE
2529: relationship_type = 'S'
2530: AND
2531: relationship_subtype = 'TASK_TO_TASK'

Line 2549: pa_object_relationships

2545: (--Get the Parents of the passed task
2546: SELECT
2547: object_id_from1 object_id
2548: FROM
2549: pa_object_relationships
2550: WHERE
2551: relationship_type = 'S'
2552: AND
2553: relationship_subtype = 'TASK_TO_TASK'

Line 2584: pa_object_relationships

2580: (-- Get the Childs of the mapped task
2581: SELECT
2582: object_id_to1 object_id
2583: FROM
2584: pa_object_relationships
2585: WHERE
2586: relationship_type ='S'
2587: AND
2588: relationship_subtype ='TASK_TO_TASK'

Line 2607: pa_object_relationships

2603: (
2604: SELECT
2605: object_id_to1 object_id
2606: FROM
2607: pa_object_relationships
2608: WHERE
2609: relationship_type ='S'
2610: AND relationship_subtype ='TASK_TO_TASK'
2611: START WITH object_id_from1 = l_task_version_id

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

2620:
2621: --End Changes by rtarway for BUG 3693360
2622:
2623:
2624: --This cursor gets the immediate parent of the passed task version id from the pa_object_relationships
2625: CURSOR c_get_immediate_parent (l_object_id_to1 NUMBER)
2626: IS
2627: SELECT
2628: OBJECT_ID_FROM1

Line 2630: pa_object_relationships

2626: IS
2627: SELECT
2628: OBJECT_ID_FROM1
2629: FROM
2630: pa_object_relationships
2631: WHERE
2632: relationship_type ='S'
2633: AND
2634: relationship_subtype ='TASK_TO_TASK'

Line 3217: , pa_object_relationships por

3213: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3214: FROM
3215: pa_proj_element_versions elemver
3216: , pa_proj_elements projelem
3217: , pa_object_relationships por
3218: WHERE
3219: projelem.project_id = elemver.project_id
3220: AND projelem.proj_element_id = elemver.proj_element_id
3221: AND elemver.object_type='PA_TASKS'

Line 3231: FROM pa_object_relationships

3227: AND elemver.project_id = l_project_id
3228: AND elemver.element_version_id IN
3229: (--Get the Parents of the passed task
3230: SELECT object_id_from1 object_id
3231: FROM pa_object_relationships
3232: WHERE relationship_type = 'S'
3233: AND relationship_subtype = 'TASK_TO_TASK'
3234: START WITH object_id_to1 = l_task_version_id
3235: CONNECT BY Object_id_to1 = PRIOR object_id_from1