[Home] [Help]
114: NVL(hr.LOCATION_ID,0)
115: INTO X_emp_id,
116: X_emp_name,
117: X_location_id
118: FROM FND_USER FND, hr_operating_units org, (SELECT p.person_id employee_id, p.full_name, a.SET_OF_BOOKS_ID , a.location_id
119: FROM PER_PEOPLE_F P,
120: PER_ALL_ASSIGNMENTS_F A,
121: PER_PERIODS_OF_SERVICE B
122: WHERE A.PERSON_ID = P.PERSON_ID
126: AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE
127: AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE
128: AND (B.ACTUAL_TERMINATION_DATE>= trunc(sysdate) or B.ACTUAL_TERMINATION_DATE is null)
129: AND P.EMPLOYEE_NUMBER IS NOT NULL) hr
130: WHERE FND.USER_ID = X_user_id
131: AND FND.EMPLOYEE_ID = hr.EMPLOYEE_ID
132: AND hr.set_of_books_id = org.set_of_books_id
133: AND org.organization_id = fnd_global.org_id
134: AND ROWNUM = 1;
146: NVL(HR.LOCATION_ID,0)
147: INTO X_emp_id,
148: X_emp_name,
149: X_location_id
150: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
151: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
152: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
153: AND ROWNUM = 1;
154:
147: INTO X_emp_id,
148: X_emp_name,
149: X_location_id
150: FROM FND_USER FND, PER_EMPLOYEES_CURRENT_X HR
151: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
152: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID
153: AND ROWNUM = 1;
154:
155: END IF ;
186: a.location_id
187: FROM per_people_f p,
188: per_all_assignments_f a,
189: per_periods_of_service ps,
190: fnd_user fnd,
191: hr_operating_units org
192: WHERE a.person_id = p.person_id
193: AND a.person_id = ps.person_id
194: AND a.assignment_type = 'E'
198: AND TRUNC(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
199: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
200: AND ( ps.actual_termination_date >= TRUNC(SYSDATE)
201: OR ps.actual_termination_date IS NULL )
202: AND fnd.user_id = TO_NUMBER(X_user_id)
203: AND fnd.employee_id = p.person_id
204: AND a.set_of_books_id = org.set_of_books_id
205: AND org.organization_id = fnd_global.org_id
206: UNION ALL
210: a.location_id
211: FROM per_people_f p,
212: per_all_assignments_f a,
213: per_periods_of_placement pp,
214: fnd_user fnd,
215: hr_operating_units org
216: WHERE a.person_id = p.person_id
217: AND a.person_id = pp.person_id
218: AND a.assignment_type = 'C'
222: AND TRUNC(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
223: AND TRUNC(SYSDATE) BETWEEN a.effective_start_date AND a.effective_end_date
224: AND ( pp.actual_termination_date >= TRUNC(SYSDATE)
225: OR pp.actual_termination_date IS NULL )
226: AND fnd.user_id = TO_NUMBER(X_user_id)
227: AND fnd.employee_id = p.person_id
228: AND a.set_of_books_id = org.set_of_books_id
229: AND org.organization_id = fnd_global.org_id
230: ) HR
242: NVL(HR.LOCATION_ID,0)
243: INTO X_emp_id,
244: X_emp_name,
245: X_location_id
246: FROM FND_USER FND, PER_WORKFORCE_CURRENT_X HR
247: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
248: AND FND.EMPLOYEE_ID = HR.PERSON_ID
249: AND ROWNUM = 1;
250:
243: INTO X_emp_id,
244: X_emp_name,
245: X_location_id
246: FROM FND_USER FND, PER_WORKFORCE_CURRENT_X HR
247: WHERE FND.USER_ID = TO_NUMBER(X_user_id)
248: AND FND.EMPLOYEE_ID = HR.PERSON_ID
249: AND ROWNUM = 1;
250:
251: END IF;
419: x_progress := '010';
420:
421: SELECT count(*)
422: INTO x_data_exists
423: FROM fnd_user
424: WHERE employee_id = x_person_id
425: AND sysdate < nvl(end_date, sysdate + 1);
426: /* DEBUG:
427: ** GK:This column has been obsoleted by AOL. Need to check