APPS.PO_MASS_UPDATE_REQ_PVT dependencies on WF_NOTIFICATIONS

Line 759: l_notification_id wf_notifications.notification_id%TYPE;

755: l_progress VARCHAR2(3) := '000';
756: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
757: l_doc_type po_document_types_all.type_name%TYPE;
758: l_auth_status po_headers.authorization_status%TYPE;
759: l_notification_id wf_notifications.notification_id%TYPE;
760: l_msg16 VARCHAR2(240);
761: l_msg17 VARCHAR2(240);
762:
763: BEGIN

Line 893: FROM wf_notifications wfn,

889: --Changed the query for bug 14393408 to handle AME Approval
890: stmt_req1 := 'SELECT wfn.notification_id,
891: por.segment1,
892: pdt.type_name
893: FROM wf_notifications wfn,
894: wf_item_activity_statuses wfa,
895: po_requisition_headers por,
896: po_document_types_vl pdt,
897: wf_items wfi

Line 913: FROM wf_notifications wfn,

909:
910: stmt_req2 := 'SELECT wfn.notification_id,
911: por.segment1,
912: pdt.type_name
913: FROM wf_notifications wfn,
914: wf_item_activity_statuses wfa,
915: po_requisition_headers por,
916: po_document_types_vl pdt
917: WHERE wfn.notification_id = wfa.notification_id