APPS.CSM_HA_EVENT_PKG dependencies on ASG_PUB_ITEM

Line 218: FROM ASG_DEFERRED_TRANINFO info, ASG_PUB_ITEM pi

214: l_pk_type_list(1):= 'VARCHAR'; l_pk_type_list(2):= 'NUMBER'; l_pk_type_list(3):= 'NUMBER';
215:
216:
217: FOR rec IN (SELECT INQ_OWNER,INQ_NAME, DEVICE_USER_NAME, DEFERRED_TRAN_ID,SEQUENCE
218: FROM ASG_DEFERRED_TRANINFO info, ASG_PUB_ITEM pi
219: WHERE info.OBJECT_NAME = pi.ITEM_ID
220: AND INQ_NAME IS NOT NULL
221: AND info.CREATION_DATE >= G_HA_START_TIME)
222: LOOP