APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_NOTIFICATIONS

Line 818: from wf_item_activity_statuses wias, wf_notifications wfn

814:
815: -- bug 3896181
816: select wfn.MESSAGE_NAME
817: into l_message_name
818: from wf_item_activity_statuses wias, wf_notifications wfn
819: where wias.notification_id = wfn.group_id
820: and wias.item_type = 'APVRMDER'
821: and wias.item_key = l_ItemKey ;
822: IF l_message_name = 'PO_ACCEPTANCE_PAST_DUE' then

Line 907: from wf_item_activity_statuses wias, wf_notifications wfn

903: to continue processing other POs in loop */
904: BEGIN
905: select wfn.MESSAGE_NAME
906: into l_message_name
907: from wf_item_activity_statuses wias, wf_notifications wfn
908: where wias.notification_id = wfn.group_id
909: and wias.item_type = 'APVRMDER'
910: and wias.item_key = l_ItemKey ;
911: EXCEPTION

Line 1176: from wf_item_activity_statuses wias, wf_notifications wfn

1172: --bug 3896181
1173: begin
1174: select wfn.MESSAGE_NAME
1175: into l_message_name
1176: from wf_item_activity_statuses wias, wf_notifications wfn
1177: where wias.notification_id = wfn.group_id
1178: and wias.item_type = 'APVRMDER'
1179: and wias.item_key = l_ItemKey ;
1180: exception

Line 1263: from wf_item_activity_statuses wias, wf_notifications wfn

1259: --bug 3896181
1260: begin
1261: select wfn.MESSAGE_NAME
1262: into l_message_name
1263: from wf_item_activity_statuses wias, wf_notifications wfn
1264: where wias.notification_id = wfn.group_id
1265: and wias.item_type = 'APVRMDER'
1266: and wias.item_key = l_ItemKey ;
1267: exception