DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on FND_USER

Line 4672: from fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl

4668: l_contract_admin_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE := NULL;
4669:
4670: CURSOR get_ctrt_admin_name IS
4671: select adminppl.full_name
4672: from fnd_user ctrtadm, PER_ALL_PEOPLE_F adminppl
4673: where p_contract_admin_id = ctrtadm.user_id(+)
4674: and ctrtadm.employee_id = adminppl.person_id(+)
4675: and adminppl.effective_start_date = adminppl.start_date;
4676: BEGIN