APPS.LNS_APPROVAL_ACTION_PUB dependencies on WF_NOTIFICATIONS

Line 2215: from WF_NOTIFICATIONS wfn

2211: +-----------------------------------------------------------------------*/
2212:
2213: CURSOR get_notification_id_cur(l_loan_number VARCHAR2, P_MESSAGE_NAME VARCHAR2, P_CURRENT_APPROVER VARCHAR2) IS
2214: select wfn.notification_id
2215: from WF_NOTIFICATIONS wfn
2216: where item_key like l_loan_number
2217: and message_name = P_MESSAGE_NAME
2218: and recipient_role = P_CURRENT_APPROVER
2219: and status = 'OPEN';