DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on WIP_SCHED_RELATIONSHIPS

Line 3381: select child_object_id from wip_sched_relationships

3377: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3378: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3379: where wip_entity_id in (select p_wip_entity_id from dual
3380: union
3381: select child_object_id from wip_sched_relationships
3382: where relationship_type = 1
3383: start with parent_object_id = p_wip_entity_id
3384: connect by prior child_object_id = parent_object_id )
3385: and organization_id = p_organization_id;

Line 3393: select child_object_id from wip_sched_relationships

3389: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3390: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3391: where wip_entity_id in (select p_wip_entity_id from dual
3392: union
3393: select child_object_id from wip_sched_relationships
3394: where relationship_type = 1
3395: start with parent_object_id = p_wip_entity_id
3396: connect by prior child_object_id = parent_object_id )
3397: and organization_id = p_organization_id;

Line 3405: select child_object_id from wip_sched_relationships

3401: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3402: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3403: where wip_entity_id in (select p_wip_entity_id from dual
3404: union
3405: select child_object_id from wip_sched_relationships
3406: where relationship_type = 1
3407: start with parent_object_id = p_wip_entity_id
3408: connect by prior child_object_id = parent_object_id )
3409: and organization_id = p_organization_id;