APPS.PO_MASS_UPDATE_PO_PVT dependencies on WF_NOTIFICATIONS

Line 1231: l_notification_id wf_notifications.notification_id%TYPE;

1227: l_progress VARCHAR2(3) := '000';
1228: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1229: l_doc_type po_document_types_all.type_name%TYPE;
1230: l_auth_status po_headers.authorization_status%TYPE;
1231: l_notification_id wf_notifications.notification_id%TYPE;
1232: l_msg16 VARCHAR2(240);
1233: l_msg17 VARCHAR2(240);
1234:
1235: BEGIN

Line 1370: FROM wf_notifications wfn,

1366:
1367: stmt_po := 'SELECT wfn.notification_id,
1368: poh.segment1,
1369: pdt.type_name
1370: FROM wf_notifications wfn,
1371: wf_item_activity_statuses wfa,
1372: po_headers poh,
1373: po_document_types_vl pdt
1374: WHERE wfn.notification_id = wfa.notification_id

Line 1571: FROM wf_notifications wfn,

1567: stmt_rel := 'SELECT wfn.notification_id,
1568: poh.segment1,
1569: por.release_num,
1570: pdt.type_name
1571: FROM wf_notifications wfn,
1572: wf_item_activity_statuses wfa,
1573: po_headers poh,
1574: po_releases por,
1575: po_document_types_vl pdt