DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1872: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

1868:
1869: --get process/activity name
1870: SELECT WPA.ACTIVITY_NAME
1871: INTO l_activity_name
1872: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1873: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1874: and WIAS.ITEM_KEY = p_eventkey
1875: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1876: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 1986: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

1982:
1983: --get process/activity name
1984: SELECT WPA.ACTIVITY_NAME
1985: INTO l_activity_name
1986: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1987: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1988: and WIAS.ITEM_KEY = p_eventkey
1989: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1990: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 2089: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

2085:
2086: --get process/activity name
2087: SELECT WPA.ACTIVITY_NAME
2088: INTO l_activity_name
2089: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
2090: where WIAS.ITEM_TYPE = 'FUNRMAIN'
2091: and WIAS.ITEM_KEY = p_eventkey
2092: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
2093: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID