DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

3473: UNION
3474: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER,
3475: A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE,
3476: IAS.BEGIN_DATE, IAS.EXECUTION_TIME
3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I

Line 3524: from WF_ITEM_ACTIVITY_STATUSES_H

3520: when NO_DATA_FOUND then
3521: begin
3522: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
3523: into l_itype, l_ikey, l_actid
3524: from WF_ITEM_ACTIVITY_STATUSES_H
3525: where notification_id = nid;
3526: exception
3527: when NO_DATA_FOUND then
3528: null; -- raise a notification not exist message