APPS.EGO_DATA_SECURITY dependencies on FND_USER

Line 172: FND_USER FND_user,

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

Line 174: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID

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

Line 175: AND fnd_user.start_date <= SYSDATE

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

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

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

Line 189: FND_USER FND_user ,

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

Line 191: WHERE HR_EMPLOYEE.PERSON_ID = FND_user.EMPLOYEE_ID

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

Line 192: AND fnd_user.start_date <= SYSDATE

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

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

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