DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on WF_NOTIFICATIONS

Line 21: wf_notifications wn,

17: * from view POR_APPROVAL_STATUS_LINES_V, an empty function body is kept here.
18: * This together with the view should be obsoleted in the next release.
19: * ******************************************SELECT pap.full_name, pap.email_address, ph.phone_number, wn.begin_date
20: FROM
21: wf_notifications wn,
22: wf_user_roles wlur,
23: fnd_user fnd,
24: po_requisition_headers_all prh,
25: per_phones ph,

Line 1618: wf_notifications wn,

1614: nvl(PH.DATE_TO, trunc(SYSDATE)) ) phone_number,
1615: wn.begin_date
1616: INTO full_name, email_address, phone, date_notified
1617: FROM
1618: wf_notifications wn,
1619: wf_notification_attributes wna,
1620: wf_user_roles wlur,
1621: fnd_user fnd,
1622: po_requisition_headers_all prh,