APPS.PA_TASKS_MAINT_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 2306: --in the hierarchy from PA_OBJECT_RELATIONSHIPS

2302: l_debug_level5 CONSTANT NUMBER := 5;
2303:
2304:
2305: --This cursor selects 'X' from dual if any non-financial task exists
2306: --in the hierarchy from PA_OBJECT_RELATIONSHIPS
2307: --for the passed task version id.
2308: CURSOR c_get_WP_rec(l_element_version_id NUMBER)
2309: IS
2310: SELECT 'X'

Line 2322: FROM pa_object_relationships

2318: WHERE element_version_id
2319: IN
2320: ( -- This select statement tries to select childs task version ids
2321: SELECT object_id_to1
2322: FROM pa_object_relationships
2323: WHERE relationship_type='S'
2324: AND relationship_subtype='TASK_TO_TASK'
2325: START WITH object_id_from1 = l_element_version_id
2326: CONNECT BY object_id_from1 = PRIOR object_id_to1