APPS.POS_ACK_PO dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 122: wf_item_activity_statuses wa

118: begin
119: select a.notification_id,poh.wf_item_type,poh.wf_item_key, a.message_name
120: INTO l_nid,l_po_item_type,l_po_item_key, l_message_name
121: from wf_notifications a,po_headers_all poh,
122: wf_item_activity_statuses wa
123: where poh.po_header_id=l_po_header_id
124: and poh.wf_item_key=wa.item_key
125: and poh.wf_item_type=wa.item_type
126: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 139: wf_item_activity_statuses wa

135: --dbms_output.put_line('For Std PO');
136: select a.notification_id,por.wf_item_type,por.wf_item_key
137: INTO l_nid,l_po_item_type,l_po_item_key
138: from wf_notifications a,po_releases_all por,
139: wf_item_activity_statuses wa
140: where por.po_release_id=l_po_release_id
141: and por.wf_item_key=wa.item_key
142: and por.wf_item_type=wa.item_type
143: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')