DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on PER_ALL_PEOPLE_F

Line 4668: l_contract_admin_name PER_ALL_PEOPLE_F.FULL_NAME%TYPE := NULL;

4664: END get_default_contract_admin_id;
4665:
4666: FUNCTION get_contract_admin_name(p_contract_admin_id NUMBER)
4667: RETURN VARCHAR2 IS
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

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