DBA Data[Home] [Help]

APPS.MSC_X_USER_EXCEP_GEN dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 3284: from wf_item_activity_statuses_h st1,wf_notifications nt

3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3282: union
3283: select nt.notification_id,nt.status
3284: from wf_item_activity_statuses_h st1,wf_notifications nt
3285: where st1.item_type = l_type
3286: and st1.item_key like l_key
3287: and
3288: nt.notification_id = st1.notification_id;

Line 3312: update wf_item_activity_statuses_h set

3308: end_date = sysdate
3309: where item_type = l_type
3310: and item_key like l_key;
3311:
3312: update wf_item_activity_statuses_h set
3313: end_date = sysdate
3314: where item_type = l_type
3315: and item_key like l_key;
3316: