APPS.PO_CHG_REQUEST_PVT dependencies on WF_NOTIFICATIONS

Line 37: from wf_notifications a, po_headers_all poh,

33: if p_po_release_id is null then
34: begin
35: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
36: INTO v_nid,l_po_item_type,l_po_item_key, l_message_name
37: from wf_notifications a, po_headers_all poh,
38: wf_item_activity_statuses wa
39: where poh.po_header_id = p_po_header_id and
40: poh.wf_item_key = wa.item_key and
41: poh.wf_item_type = wa.item_type

Line 53: from wf_notifications a, po_releases_all por,

49: else
50: begin
51: select a.notification_id,por.wf_item_type,por.wf_item_key, a.message_name
52: INTO v_nid,l_po_item_type,l_po_item_key, l_message_name
53: from wf_notifications a, po_releases_all por,
54: wf_item_activity_statuses wa
55: where por.po_release_id = p_po_release_id and
56: por.wf_item_key = wa.item_key and
57: por.wf_item_type = wa.item_type

Line 97: from wf_notifications a, wf_item_activity_statuses wa

93: BEGIN
94: begin
95: select a.notification_id
96: INTO v_nid
97: from wf_notifications a, wf_item_activity_statuses wa
98: where wa.item_key = p_item_key and
99: wa.item_type = p_item_type and
100: a.message_name = 'PO_SUPPLIER_SIGNATURE' and
101: a.status = 'OPEN' and