APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 3237: select child_object_id from wip_sched_relationships

3233: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3234: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3235: where wip_entity_id in (select p_wip_entity_id from dual
3236: union
3237: select child_object_id from wip_sched_relationships
3238: where relationship_type = 1
3239: start with parent_object_id = p_wip_entity_id
3240: connect by prior child_object_id = parent_object_id )
3241: and organization_id = p_organization_id;

Line 3249: select child_object_id from wip_sched_relationships

3245: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3246: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3247: where wip_entity_id in (select p_wip_entity_id from dual
3248: union
3249: select child_object_id from wip_sched_relationships
3250: where relationship_type = 1
3251: start with parent_object_id = p_wip_entity_id
3252: connect by prior child_object_id = parent_object_id )
3253: and organization_id = p_organization_id;

Line 3261: select child_object_id from wip_sched_relationships

3257: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3258: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3259: where wip_entity_id in (select p_wip_entity_id from dual
3260: union
3261: select child_object_id from wip_sched_relationships
3262: where relationship_type = 1
3263: start with parent_object_id = p_wip_entity_id
3264: connect by prior child_object_id = parent_object_id )
3265: and organization_id = p_organization_id;