APPS.DPP_BUSINESSEVENTS_PVT dependencies on FND_USER

Line 486: FROM DPP_TRANSACTION_HEADERS_ALL H, FND_USER U

482: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_EFFECTIVE_DATE_NOTIF';
483:
484: CURSOR GET_USER_LIST (P_PROGRAM_ID VARCHAR2) IS
485: SELECT DISTINCT H.CREATED_BY, U.USER_NAME
486: FROM DPP_TRANSACTION_HEADERS_ALL H, FND_USER U
487: WHERE TRUNC(H.EFFECTIVE_START_DATE) < TRUNC(SYSDATE)
488: AND H.REQUEST_ID=P_PROGRAM_ID
489: AND H.TRANSACTION_STATUS = 'PENDING_ADJUSTMENT'
490: AND H.CREATED_BY=U.USER_ID;

Line 668: FROM fnd_user

664: --Get the user name corresponding to the user id
665: BEGIN
666: SELECT user_name
667: INTO l_user_name
668: FROM fnd_user
669: WHERE user_id = l_user_id ;
670:
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN