DBA Data[Home] [Help]

APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_NOTIFICATIONS

Line 806: from wf_item_activity_statuses wias, wf_notifications wfn

802:
803: -- bug 3896181
804: select wfn.MESSAGE_NAME
805: into l_message_name
806: from wf_item_activity_statuses wias, wf_notifications wfn
807: where wias.notification_id = wfn.group_id
808: and wias.item_type = 'APVRMDER'
809: and wias.item_key = l_ItemKey ;
810: IF l_message_name = 'PO_ACCEPTANCE_PAST_DUE' then

Line 887: from wf_item_activity_statuses wias, wf_notifications wfn

883: END IF;
884: -- bug 3896181
885: select wfn.MESSAGE_NAME
886: into l_message_name
887: from wf_item_activity_statuses wias, wf_notifications wfn
888: where wias.notification_id = wfn.group_id
889: and wias.item_type = 'APVRMDER'
890: and wias.item_key = l_ItemKey ;
891: IF l_message_name = 'PO_ACCEPTANCE_REQUIRED' then

Line 1147: from wf_item_activity_statuses wias, wf_notifications wfn

1143: --bug 3896181
1144: begin
1145: select wfn.MESSAGE_NAME
1146: into l_message_name
1147: from wf_item_activity_statuses wias, wf_notifications wfn
1148: where wias.notification_id = wfn.group_id
1149: and wias.item_type = 'APVRMDER'
1150: and wias.item_key = l_ItemKey ;
1151: exception

Line 1234: from wf_item_activity_statuses wias, wf_notifications wfn

1230: --bug 3896181
1231: begin
1232: select wfn.MESSAGE_NAME
1233: into l_message_name
1234: from wf_item_activity_statuses wias, wf_notifications wfn
1235: where wias.notification_id = wfn.group_id
1236: and wias.item_type = 'APVRMDER'
1237: and wias.item_key = l_ItemKey ;
1238: exception