APPS.PA_TASKS_MAINT_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 2535: pa_object_relationships

2531: (--Get the Parents of the passed task
2532: SELECT
2533: object_id_from1 object_id
2534: FROM
2535: pa_object_relationships
2536: WHERE
2537: relationship_type = 'S'
2538: AND
2539: relationship_subtype = 'TASK_TO_TASK'

Line 2557: pa_object_relationships

2553: (--Get the Parents of the passed task
2554: SELECT
2555: object_id_from1 object_id
2556: FROM
2557: pa_object_relationships
2558: WHERE
2559: relationship_type = 'S'
2560: AND
2561: relationship_subtype = 'TASK_TO_TASK'

Line 2592: pa_object_relationships

2588: (-- Get the Childs of the mapped task
2589: SELECT
2590: object_id_to1 object_id
2591: FROM
2592: pa_object_relationships
2593: WHERE
2594: relationship_type ='S'
2595: AND
2596: relationship_subtype ='TASK_TO_TASK'

Line 2615: pa_object_relationships

2611: (
2612: SELECT
2613: object_id_to1 object_id
2614: FROM
2615: pa_object_relationships
2616: WHERE
2617: relationship_type ='S'
2618: AND relationship_subtype ='TASK_TO_TASK'
2619: START WITH object_id_from1 = l_task_version_id

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

2628:
2629: --End Changes by rtarway for BUG 3693360
2630:
2631:
2632: --This cursor gets the immediate parent of the passed task version id from the pa_object_relationships
2633: CURSOR c_get_immediate_parent (l_object_id_to1 NUMBER)
2634: IS
2635: SELECT
2636: OBJECT_ID_FROM1

Line 2638: pa_object_relationships

2634: IS
2635: SELECT
2636: OBJECT_ID_FROM1
2637: FROM
2638: pa_object_relationships
2639: WHERE
2640: relationship_type ='S'
2641: AND
2642: relationship_subtype ='TASK_TO_TASK'

Line 3225: , pa_object_relationships por

3221: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3222: FROM
3223: pa_proj_element_versions elemver
3224: , pa_proj_elements projelem
3225: , pa_object_relationships por
3226: WHERE
3227: projelem.project_id = elemver.project_id
3228: AND projelem.proj_element_id = elemver.proj_element_id
3229: AND elemver.object_type='PA_TASKS'

Line 3239: FROM pa_object_relationships

3235: AND elemver.project_id = l_project_id
3236: AND elemver.element_version_id IN
3237: (--Get the Parents of the passed task
3238: SELECT object_id_from1 object_id
3239: FROM pa_object_relationships
3240: WHERE relationship_type = 'S'
3241: AND relationship_subtype = 'TASK_TO_TASK'
3242: START WITH object_id_to1 = l_task_version_id
3243: CONNECT BY Object_id_to1 = PRIOR object_id_from1