DBA Data[Home] [Help]

APPS.WSH_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 629: FROM wf_item_activity_statuses

625: document_type in out NOCOPY varchar2) IS
626:
627: CURSOR c_get_itemkey(c_document_id in varchar2) is
628: SELECT item_key
629: FROM wf_item_activity_statuses
630: WHERE notification_id = to_number(c_document_id);
631:
632: l_item_type varchar2(30) := 'WSHNOTIF';
633: l_item_key varchar2(150);

Line 784: FROM wf_item_activity_statuses

780: document_type in out NOCOPY varchar2) IS
781:
782: CURSOR c_get_itemkey (c_document_id in number) is
783: SELECT item_key
784: FROM wf_item_activity_statuses
785: WHERE notification_id = to_number(c_document_id);
786:
787: l_item_type varchar2(30) := 'WSHNOTIF';
788: l_item_key varchar2(150);