APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 2457: FROM mtl_object_genealogy mog

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

Line 2467: FROM mtl_object_genealogy mog

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

Line 3035: FROM mtl_object_genealogy mog

3031: INTO l_hr_exists
3032: FROM DUAL
3033: WHERE EXISTS
3034: (SELECT mog.object_id
3035: FROM mtl_object_genealogy mog
3036: WHERE mog.object_id = l_gen_object_id
3037:
3038: -- Fix for bug 2219479. We do not allow assets that are
3039: -- a child or a parent in the future to be deactivated.

Line 3045: FROM mtl_object_genealogy mog

3041:
3042: AND sysdate <= nvl(mog.end_date_active(+), sysdate))
3043: OR EXISTS
3044: (SELECT mog.object_id
3045: FROM mtl_object_genealogy mog
3046: WHERE mog.parent_object_id = l_gen_object_id
3047: AND sysdate <= nvl(mog.end_date_active(+), sysdate));
3048:
3049: exception