APPS.PO_CHANGEORDERWF_PVT dependencies on WF_NOTIFICATIONS

Line 1183: from wf_notifications a,

1179: --dbms_output.put_line('For std pos');
1180: begin
1181: select a.notification_id, a.recipient_role
1182: INTO l_nid, l_ntf_role_name
1183: from wf_notifications a,
1184: wf_item_activity_statuses wa
1185: where itemkey=wa.item_key
1186: and itemtype=wa.item_type
1187: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 1198: from wf_notifications a,

1194: begin
1195: --dbms_output.put_line('For Releases');
1196: select a.notification_id, a.recipient_role
1197: INTO l_nid, l_ntf_role_name
1198: from wf_notifications a,
1199: wf_item_activity_statuses wa
1200: where itemkey=wa.item_key
1201: and itemtype=wa.item_type
1202: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 8786: wf_notifications wfn

8782:
8783: SELECT fu.USER_ID
8784: INTO l_responder_id
8785: FROM fnd_user fu,
8786: wf_notifications wfn
8787: WHERE wfn.notification_id = l_notification_id
8788: AND wfn.original_recipient = fu.user_name;
8789:
8790: l_progress := 'PO_ChangeOrderWF_PVT.post_approval_notif: 04.' ;