APPS.PO_MASS_UPDATE_REQ_PVT dependencies on WF_NOTIFICATIONS

Line 755: l_notification_id wf_notifications.notification_id%TYPE;

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

Line 887: FROM wf_notifications wfn,

883:
884: stmt_req := 'SELECT wfn.notification_id,
885: por.segment1,
886: pdt.type_name
887: FROM wf_notifications wfn,
888: wf_item_activity_statuses wfa,
889: po_requisition_headers por,
890: po_document_types_vl pdt
891: WHERE wfn.notification_id = wfa.notification_id