DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on PER_ALL_PEOPLE_F

Line 3358: ,PER_ALL_PEOPLE_F P

3354:
3355: Cursor Get_Emp_User IS
3356: SELECT P.FULL_NAME
3357: FROM FND_USER fu
3358: ,PER_ALL_PEOPLE_F P
3359: WHERE sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3360: AND nvl(fu.end_date, sysdate+1)
3361: AND fu.employee_id = P.person_id
3362: AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE