DBA Data[Home] [Help]

APPS.OKC_CRT_PVT dependencies on FND_USER_VIEW

Line 567: from fnd_user_view

563: p_crtv_rec IN crtv_rec_TYPE) is
564: l_dummy_var varchar2(1) := '?';
565: cursor l_user_csr is
566: select 'x'
567: from fnd_user_view
568: where user_id = p_crtv_rec.user_id;
569: begin
570: x_return_status := OKC_API.G_RET_STS_SUCCESS;
571: if (p_crtv_rec.user_id is NULL or p_crtv_rec.user_id = OKC_API.G_MISS_NUM) then

Line 929: FROM Fnd_User_View

925: USER_NAME,
926: ENCRYPTED_FOUNDATION_PASSWORD,
927: START_DATE,
928: END_DATE
929: FROM Fnd_User_View
930: WHERE fnd_user_view.user_id = p_user_id;
931: l_fnd_userv_pk fnd_userv_pk_csr%ROWTYPE;
932: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
933: SELECT

Line 930: WHERE fnd_user_view.user_id = p_user_id;

926: ENCRYPTED_FOUNDATION_PASSWORD,
927: START_DATE,
928: END_DATE
929: FROM Fnd_User_View
930: WHERE fnd_user_view.user_id = p_user_id;
931: l_fnd_userv_pk fnd_userv_pk_csr%ROWTYPE;
932: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
933: SELECT
934: ID,