DBA Data[Home] [Help]

APPS.FUN_WF_COMMON dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1195: from WF_ITEM_ACTIVITY_STATUSES

1191: IS
1192:
1193: cursor batch_abort is
1194: select distinct item_type,item_key
1195: from WF_ITEM_ACTIVITY_STATUSES
1196: where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
1197: and item_key like to_char(p_batch_id)||'%'
1198: and activity_status in( 'ACTIVE');
1199:

Line 1202: from WF_ITEM_ACTIVITY_STATUSES

1198: and activity_status in( 'ACTIVE');
1199:
1200: cursor trx_abort is
1201: select distinct item_type,item_key
1202: from WF_ITEM_ACTIVITY_STATUSES
1203: where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
1204: and item_key like to_char(p_batch_id)||'_'||to_char(p_trx_id)||'%'
1205: and activity_status in( 'ACTIVE');
1206: