APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 2458: FROM mtl_object_genealogy mog

2454: INTO l_hr_exists
2455: FROM DUAL
2456: WHERE EXISTS
2457: (SELECT mog.object_id
2458: FROM mtl_object_genealogy mog
2459: WHERE mog.object_id = l_gen_object_id
2460:
2461: -- Fix for bug 2219479. We do not allow assets that are
2462: -- a child or a parent in the future to be deactivated.

Line 2468: FROM mtl_object_genealogy mog

2464:
2465: AND sysdate <= nvl(mog.end_date_active(+), sysdate))
2466: OR EXISTS
2467: (SELECT mog.object_id
2468: FROM mtl_object_genealogy mog
2469: WHERE mog.parent_object_id = l_gen_object_id
2470: AND sysdate <= nvl(mog.end_date_active(+), sysdate));
2471:
2472: exception

Line 3175: FROM mtl_object_genealogy mog

3171: INTO l_hr_exists
3172: FROM DUAL
3173: WHERE EXISTS
3174: (SELECT mog.object_id
3175: FROM mtl_object_genealogy mog
3176: WHERE mog.object_id = l_gen_object_id
3177:
3178: -- Fix for bug 2219479. We do not allow assets that are
3179: -- a child or a parent in the future to be deactivated.

Line 3185: FROM mtl_object_genealogy mog

3181:
3182: AND sysdate <= nvl(mog.end_date_active(+), sysdate))
3183: OR EXISTS
3184: (SELECT mog.object_id
3185: FROM mtl_object_genealogy mog
3186: WHERE mog.parent_object_id = l_gen_object_id
3187: AND sysdate <= nvl(mog.end_date_active(+), sysdate));
3188:
3189: exception