DBA Data[Home] [Help]

APPS.FUN_WF_COMMON dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1389: from WF_ITEM_ACTIVITY_STATUSES

1385: IS
1386:
1387: cursor batch_abort is
1388: select distinct item_type,item_key
1389: from WF_ITEM_ACTIVITY_STATUSES
1390: where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
1391: and item_key like to_char(p_batch_id)||'%'
1392: and activity_status in( 'ACTIVE');
1393:

Line 1396: from WF_ITEM_ACTIVITY_STATUSES

1392: and activity_status in( 'ACTIVE');
1393:
1394: cursor trx_abort is
1395: select distinct item_type,item_key
1396: from WF_ITEM_ACTIVITY_STATUSES
1397: where item_type in ('FUNRMAIN','FUNIMAIN','FUNRTVAL','FUNMSYST')
1398: and item_key like to_char(p_batch_id)||'_'||to_char(p_trx_id)||'%'
1399: and activity_status in( 'ACTIVE');
1400:

Line 1443: from WF_ITEM_ACTIVITY_STATUSES

1439: IS
1440:
1441: cursor trx_abort is
1442: select distinct item_type,item_key
1443: from WF_ITEM_ACTIVITY_STATUSES
1444: where item_type = p_item_type
1445: and item_key like to_char(p_batch_id)||'_'||to_char(p_trx_id)||'%'
1446: and activity_status in('ACTIVE');
1447: