APPS.PO_MASS_UPDATE_PO_PVT dependencies on WF_NOTIFICATIONS

Line 1304: l_notification_id wf_notifications.notification_id%TYPE;

1300: l_progress VARCHAR2(3) := '000';
1301: l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Approver';
1302: l_doc_type po_document_types_all.type_name%TYPE;
1303: l_auth_status po_headers.authorization_status%TYPE;
1304: l_notification_id wf_notifications.notification_id%TYPE;
1305: l_msg16 VARCHAR2(240);
1306: l_msg17 VARCHAR2(240);
1307:
1308: BEGIN

Line 1443: FROM wf_notifications wfn,

1439:
1440: stmt_po := 'SELECT wfn.notification_id,
1441: poh.segment1,
1442: pdt.type_name
1443: FROM wf_notifications wfn,
1444: wf_item_activity_statuses wfa,
1445: po_headers poh,
1446: po_document_types_vl pdt
1447: WHERE wfn.notification_id = wfa.notification_id

Line 1644: FROM wf_notifications wfn,

1640: stmt_rel := 'SELECT wfn.notification_id,
1641: poh.segment1,
1642: por.release_num,
1643: pdt.type_name
1644: FROM wf_notifications wfn,
1645: wf_item_activity_statuses wfa,
1646: po_headers poh,
1647: po_releases por,
1648: po_document_types_vl pdt