DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 8999: from wf_item_activity_statuses_v was, wf_notifications wfn

8995: l_next_flag boolean:=true;
8996:
8997: cursor l_notif_status_csr(activity in varchar2) is
8998: select wfn.status, wfn.notification_id
8999: from wf_item_activity_statuses_v was, wf_notifications wfn
9000: where was.item_type=l_item_type
9001: and was.item_key=l_item_key
9002: and was.activity_name=activity
9003: and was.notification_id=wfn.notification_id;