DBA Data[Home] [Help]

APPS.AHL_PC_NODE_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 504: FROM ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre

500:
501: -- Checking if the linked Node has any MR Effectivities defined
502: SELECT distinct 'X'
503: INTO l_exist
504: FROM ahl_mr_headers_app_v mrh, ahl_mr_effectivities mre
505: WHERE
506: -- R12 [priyan MEL/CDL]
507: -- to prevent foreign key violations checking for any MR effectivity associated (instead of just active ones)
508: -- trunc(sysdate) < trunc(nvl(mrh.effective_to, sysdate+1)) and