APPS.PO_CHANGEORDERWF_PVT dependencies on WF_NOTIFICATIONS

Line 1088: from wf_notifications a,

1084: --dbms_output.put_line('For std pos');
1085: begin
1086: select a.notification_id, a.recipient_role
1087: INTO l_nid, l_ntf_role_name
1088: from wf_notifications a,
1089: wf_item_activity_statuses wa
1090: where itemkey=wa.item_key
1091: and itemtype=wa.item_type
1092: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 1103: from wf_notifications a,

1099: begin
1100: --dbms_output.put_line('For Releases');
1101: select a.notification_id, a.recipient_role
1102: INTO l_nid, l_ntf_role_name
1103: from wf_notifications a,
1104: wf_item_activity_statuses wa
1105: where itemkey=wa.item_key
1106: and itemtype=wa.item_type
1107: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')