DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on FND_REQUEST_GROUP_UNITS

Line 482: AND NOT EXISTS (SELECT 1 FROM FND_REQUEST_GROUP_UNITS

478: FOR rec in (SELECT B.APPLICATION_SHORT_NAME APP_NAME, CONCURRENT_PROGRAM_NAME
479: FROM CSM_HA_ACTIVE_CONC_DATA a, FND_APPLICATION b
480: WHERE a.APPLICATION_ID = b.APPLICATION_ID
481: AND a.APPLICATION_ID NOT IN (0,1)
482: AND NOT EXISTS (SELECT 1 FROM FND_REQUEST_GROUP_UNITS
483: WHERE UNIT_APPLICATION_ID=a.APPLICATION_ID
484: AND REQUEST_UNIT_ID=a.CONCURRENT_PROGRAM_ID
485: AND APPLICATION_ID=l_app_id
486: AND REQUEST_GROUP_ID=l_grp_id))