DBA Data[Home] [Help]

APPS.EGO_DATA_SECURITY dependencies on PER_ALL_PEOPLE_F

Line 173: PER_ALL_PEOPLE_F HR_EMPLOYEE

169: IF l_party_id IS NULL THEN
170: SELECT count(1) into l_count
171: FROM hz_parties employee,
172: FND_USER FND_user,
173: PER_ALL_PEOPLE_F HR_EMPLOYEE
174: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
175: AND fnd_user.start_date <= SYSDATE
176: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE
177: AND (HR_EMPLOYEE.CURRENT_EMPLOYEE_FLAG = 'Y'

Line 190: PER_ALL_PEOPLE_F HR_EMPLOYEE

186: ELSE
187: SELECT Count(1) into l_count
188: FROM hz_parties employee ,
189: FND_USER FND_user ,
190: PER_ALL_PEOPLE_F HR_EMPLOYEE
191: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID
192: AND fnd_user.start_date <= SYSDATE
193: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE
194: AND (HR_EMPLOYEE.CURRENT_EMPLOYEE_FLAG = 'Y'