APPS.LNS_WORK_FLOW dependencies on WF_NOTIFICATIONS

Line 121: from wf_notifications

117: +-----------------------------------------------------------------------*/
118:
119: CURSOR csr_notification (p_itemtype varchar2, p_itemkey varchar2) IS
120: select NOTIFICATION_ID, responder
121: from wf_notifications
122: where MESSAGE_TYPE = p_itemtype and
123: ITEM_KEY = p_itemkey;
124:
125: CURSOR csr_user_id (p_user_name varchar2) IS

Line 1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;

1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1438: l_current_user_name fnd_user.user_name%TYPE;
1439:
1440: /*-----------------------------------------------------------------------+

Line 1451: FROM WF_NOTIFICATIONS

1447: WHERE fndu.user_id = current_user_id;
1448:
1449: CURSOR get_notifications_for_close(search_criteria varchar2) IS
1450: SELECT notification_id
1451: FROM WF_NOTIFICATIONS
1452: WHERE item_key like search_criteria
1453: AND message_name = 'MSG_LOAN_TO_BE_APPROVED'
1454: AND status = 'OPEN';
1455: