DBA Data[Home] [Help]

APPS.EGO_DATA_SECURITY dependencies on PER_ALL_PEOPLE_F

Line 174: PER_ALL_PEOPLE_F HR_EMPLOYEE

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

Line 191: PER_ALL_PEOPLE_F HR_EMPLOYEE

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