APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 58: from wf_item_activity_statuses_v

54: l_auction_approval_status = 'NOT_REQUIRED') then
55: begin
56: select activity_label
57: into l_activity_status
58: from wf_item_activity_statuses_v
59: where item_type = 'PONAPPRV'
60: and item_key = p_top_process_item_key
61: and activity_status_code = 'NOTIFIED';
62: exception when others then

Line 82: from wf_item_activity_statuses_v

78: begin
79: begin
80: select activity_label
81: into l_activity_status
82: from wf_item_activity_statuses_v
83: where item_type = 'PONAPPRV'
84: and item_key = p_top_process_item_key
85: and activity_status_code = 'NOTIFIED';
86: exception when others then

Line 218: from wf_item_activity_statuses_v

214:
215: Procedure Close_Child_Process(p_parent_item_key Varchar2) is
216: Cursor List_of_Process(p_item_type varchar2, p_parent_item_key Varchar2) is
217: select activity_label, item_key,notification_id
218: from wf_item_activity_statuses_v
219: where item_type = p_item_type
220: and item_key like p_parent_item_key || '_%'
221: and activity_status_code = 'NOTIFIED';
222: l_item_type Varchar2(30) := 'PONAPPRV';