APPS.PON_AUCTION_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 3244: from wf_item_activity_statuses_v

3240: --
3241: BEGIN
3242: select activity_label
3243: into x_current_activity
3244: from wf_item_activity_statuses_v
3245: where item_type = x_itemtype
3246: AND item_key = x_itemkey
3247: and activity_status_code = 'NOTIFIED';
3248: EXCEPTION WHEN no_data_found THEN

Line 3269: wf_item_activity_statuses_v act

3265:
3266: CURSOR bidder_list_wf_keys IS
3267: select pbp.wf_item_key wf_item_key, act.activity_label activity_label
3268: from pon_bidding_parties pbp,
3269: wf_item_activity_statuses_v act
3270: where pbp.auction_header_id = p_prev_doc_header_id and
3271: act.item_type = x_itemtype and
3272: act.item_key = pbp.wf_item_key and
3273: act.activity_status_code = 'NOTIFIED';

Line 5011: from wf_item_activity_statuses_v

5007: --
5008: BEGIN
5009: select activity_label
5010: into x_current_activity
5011: from wf_item_activity_statuses_v
5012: where item_type = x_itemtype
5013: AND item_key = x_itemkey
5014: and activity_status_code = 'NOTIFIED';
5015: EXCEPTION WHEN no_data_found THEN

Line 5794: from wf_item_activity_statuses_v

5790: --
5791: BEGIN
5792: select activity_label
5793: into x_current_activity
5794: from wf_item_activity_statuses_v
5795: where item_type = x_itemtype
5796: AND item_key = x_itemkey
5797: and activity_status_code = 'NOTIFIED';
5798: EXCEPTION WHEN no_data_found THEN

Line 5960: from wf_item_activity_statuses_v

5956: --
5957: BEGIN
5958: select activity_label
5959: into x_current_activity
5960: from wf_item_activity_statuses_v
5961: where item_type = x_itemtype
5962: AND item_key = x_itemkey
5963: and activity_status_code = 'NOTIFIED';
5964: EXCEPTION WHEN no_data_found THEN

Line 6072: from wf_item_activity_statuses_v

6068: --
6069: BEGIN
6070: select activity_label
6071: into x_current_activity
6072: from wf_item_activity_statuses_v
6073: where item_type = x_itemtype
6074: AND item_key = x_itemkey
6075: and activity_status_code = 'NOTIFIED';
6076: EXCEPTION WHEN no_data_found THEN