DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on PER_ALL_PEOPLE_F

Line 3348: ,PER_ALL_PEOPLE_F P

3344:
3345: Cursor Get_Emp_User IS
3346: SELECT P.FULL_NAME
3347: FROM FND_USER fu
3348: ,PER_ALL_PEOPLE_F P
3349: WHERE sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3350: AND nvl(fu.end_date, sysdate+1)
3351: AND fu.employee_id = P.person_id
3352: AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE