APPS.EGO_DATA_SECURITY dependencies on FND_USER

Line 173: FND_USER FND_user,

169: IF p_object_name IN ('EGO_ITEM','ENG_CHANGE','HZ_PARTIES') THEN
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

Line 175: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID

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'
179: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y'

Line 176: AND fnd_user.start_date <= SYSDATE

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'
179: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y'
180: )

Line 177: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

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'
179: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y'
180: )
181: AND HR_EMPLOYEE.EFFECTIVE_START_DATE <= SYSDATE

Line 190: FND_USER FND_user ,

186: AND user_name = p_user_name;
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

Line 192: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID

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'
196: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y')

Line 193: AND fnd_user.start_date <= SYSDATE

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'
196: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y')
197: AND HR_EMPLOYEE.EFFECTIVE_START_DATE <= SYSDATE

Line 194: AND NVL(fnd_user.end_date, SYSDATE) >= SYSDATE

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'
196: OR HR_EMPLOYEE.CURRENT_NPW_FLAG = 'Y')
197: AND HR_EMPLOYEE.EFFECTIVE_START_DATE <= SYSDATE
198: AND NVL(HR_EMPLOYEE.EFFECTIVE_END_DATE,SYSDATE) >= SYSDATE