DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on WF_PROCESS_ACTIVITIES

Line 1747: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

1743:
1744: --get process/activity name
1745: SELECT WPA.ACTIVITY_NAME
1746: INTO l_activity_name
1747: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1748: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1749: and WIAS.ITEM_KEY = p_eventkey
1750: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1751: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 1861: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

1857:
1858: --get process/activity name
1859: SELECT WPA.ACTIVITY_NAME
1860: INTO l_activity_name
1861: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
1862: where WIAS.ITEM_TYPE = 'FUNRMAIN'
1863: and WIAS.ITEM_KEY = p_eventkey
1864: and WIAS.ACTIVITY_STATUS = wf_engine.eng_notified
1865: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID