DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 9386: from wf_item_activity_statuses_v was, wf_notifications wfn

9382: l_next_flag boolean:=true;
9383:
9384: cursor l_notif_status_csr(activity in varchar2) is
9385: select wfn.status, wfn.notification_id
9386: from wf_item_activity_statuses_v was, wf_notifications wfn
9387: where was.item_type=l_item_type
9388: and was.item_key=l_item_key
9389: and was.activity_name=activity
9390: and was.notification_id=wfn.notification_id;