eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DISCOVERER dependencies on PER_ASSIGNMENTS_F

Line 37: per_assignments_f a

33: a.location_id,
34: b.date_start,
35: SYSDATE
36: FROM per_periods_of_service b,
37: per_assignments_f a
38: WHERE (TRUNC(SYSDATE)
39: BETWEEN TRUNC(a.effective_start_date)
40: AND TRUNC(a.effective_end_date))
41: AND a.assignment_id = p_assignment_id

Line 57: per_assignments_f a

53: b.date_start,
54: b.actual_termination_date
55: FROM per_periods_of_service b,
56: per_assignment_status_types c,
57: per_assignments_f a
58: WHERE (TRUNC(SYSDATE) > TRUNC(a.effective_end_date))
59: AND a.assignment_id = p_assignment_id
60: AND a.period_of_service_id = b.period_of_service_id
61: AND a.assignment_status_type_id = c.assignment_status_type_id

Line 88: per_assignments_f a,

84: l_location_id,
85: l_service_date_start,
86: l_actual_termination_date
87: FROM per_periods_of_service b,
88: per_assignments_f a,
89: per_assignment_status_types c
90: WHERE a.assignment_id = p_assignment_id
91: AND a.period_of_service_id = b.period_of_service_id
92: AND a.assignment_status_type_id = c.assignment_status_type_id

Line 146: FROM per_assignments_f ass

142: ELSIF p_mode = 'ORGANIZATION' THEN
143: --
144: SELECT MIN(ass.effective_start_date)
145: INTO l_date_start
146: FROM per_assignments_f ass
147: WHERE ass.organization_id = l_organization_id
148: AND ass.assignment_id = p_assignment_id
149: AND ass.assignment_type = 'E'
150: AND NOT EXISTS

Line 153: FROM per_assignments_f ass1

149: AND ass.assignment_type = 'E'
150: AND NOT EXISTS
151: (
152: SELECT null
153: FROM per_assignments_f ass1
154: WHERE ass1.assignment_id = ass.assignment_id
155: AND NVL(ass1.organization_id,9.9)+0 = NVL(ass.organization_id,9.9)+0
156: AND ass1.effective_start_date =
157: (

Line 159: FROM per_assignments_f ass2

155: AND NVL(ass1.organization_id,9.9)+0 = NVL(ass.organization_id,9.9)+0
156: AND ass1.effective_start_date =
157: (
158: SELECT MAX(ass2.effective_start_date)
159: FROM per_assignments_f ass2
160: WHERE ass2.assignment_id = ass1.assignment_id
161: AND ass2.effective_start_date < ass.effective_start_date
162: )
163: AND ass1.assignment_type = 'E'

Line 172: FROM per_assignments_f cass

168: -- checking for organization changes
169: --
170: SELECT MAX(cass.effective_end_date+1)
171: INTO l_change_date
172: FROM per_assignments_f cass
173: WHERE cass.assignment_id = p_assignment_id
174: AND cass.organization_id <> l_organization_id
175: AND cass.effective_start_date > l_date_start
176: AND cass.effective_end_date < l_actual_termination_date;

Line 186: FROM per_assignments_f ass

182: ELSIF p_mode = 'JOB' THEN
183: --
184: SELECT MIN(ass.effective_start_date)
185: INTO l_date_start
186: FROM per_assignments_f ass
187: WHERE ass.job_id = l_job_id
188: AND ass.assignment_id = p_assignment_id
189: AND ass.assignment_type = 'E'
190: AND NOT EXISTS

Line 193: FROM per_assignments_f ass1

189: AND ass.assignment_type = 'E'
190: AND NOT EXISTS
191: (
192: SELECT null
193: FROM per_assignments_f ass1
194: WHERE ass1.assignment_id = ass.assignment_id
195: AND NVL(ass1.job_id,9.9)+0 = NVL(ass.job_id,9.9)+0
196: AND ass1.effective_start_date =
197: (

Line 199: FROM per_assignments_f ass2

195: AND NVL(ass1.job_id,9.9)+0 = NVL(ass.job_id,9.9)+0
196: AND ass1.effective_start_date =
197: (
198: SELECT MAX(ass2.effective_start_date)
199: FROM per_assignments_f ass2
200: WHERE ass2.assignment_id = ass1.assignment_id
201: AND ass2.effective_start_date < ass.effective_start_date
202: )
203: AND ass1.assignment_type = 'E'

Line 212: FROM per_assignments_f cass

208: -- checking for job changes
209: --
210: SELECT MAX(cass.effective_end_date+1)
211: INTO l_change_date
212: FROM per_assignments_f cass
213: WHERE cass.assignment_id = p_assignment_id
214: AND cass.job_id <> l_job_id
215: AND cass.effective_start_date > l_date_start
216: AND cass.effective_end_date < l_actual_termination_date;

Line 226: FROM per_assignments_f ass

222: ELSIF p_mode = 'POSITION' THEN
223: --
224: SELECT MIN(ass.effective_start_date)
225: INTO l_date_start
226: FROM per_assignments_f ass
227: WHERE ass.position_id = l_position_id
228: AND ass.assignment_id = p_assignment_id
229: AND ass.assignment_type = 'E'
230: AND NOT EXISTS

Line 233: FROM per_assignments_f ass1

229: AND ass.assignment_type = 'E'
230: AND NOT EXISTS
231: (
232: SELECT null
233: FROM per_assignments_f ass1
234: WHERE ass1.assignment_id = ass.assignment_id
235: AND NVL(ass1.position_id,9.9)+0 =
236: NVL(ass.position_id,9.9)+0
237: AND ass1.effective_start_date =

Line 240: FROM per_assignments_f ass2

236: NVL(ass.position_id,9.9)+0
237: AND ass1.effective_start_date =
238: (
239: SELECT MAX(ass2.effective_start_date)
240: FROM per_assignments_f ass2
241: WHERE ass2.assignment_id = ass1.assignment_id
242: AND ass2.effective_start_date < ass.effective_start_date
243: )
244: AND ass1.assignment_type = 'E'

Line 253: FROM per_assignments_f cass

249: -- checking for position changes
250: --
251: SELECT MAX(cass.effective_end_date+1)
252: INTO l_change_date
253: FROM per_assignments_f cass
254: WHERE cass.assignment_id = p_assignment_id
255: AND cass.position_id <> l_position_id
256: AND cass.effective_start_date > l_date_start
257: AND cass.effective_end_date < l_actual_termination_date;

Line 267: FROM per_assignments_f ass

263: ELSIF p_mode = 'GRADE' THEN
264: --
265: SELECT MIN(ass.effective_start_date)
266: INTO l_date_start
267: FROM per_assignments_f ass
268: WHERE ass.grade_id = l_grade_id
269: AND ass.assignment_id = p_assignment_id
270: AND ass.assignment_type = 'E'
271: AND NOT EXISTS

Line 274: FROM per_assignments_f ass1

270: AND ass.assignment_type = 'E'
271: AND NOT EXISTS
272: (
273: SELECT null
274: FROM per_assignments_f ass1
275: WHERE ass1.assignment_id = ass.assignment_id
276: AND NVL(ass1.grade_id,9.9)+0 = NVL(ass.grade_id,9.9)+0
277: AND ass1.effective_start_date =
278: (

Line 280: FROM per_assignments_f ass2

276: AND NVL(ass1.grade_id,9.9)+0 = NVL(ass.grade_id,9.9)+0
277: AND ass1.effective_start_date =
278: (
279: SELECT MAX(ass2.effective_start_date)
280: FROM per_assignments_f ass2
281: WHERE ass2.assignment_id = ass1.assignment_id
282: AND ass2.effective_start_date < ass.effective_start_date
283: )
284: AND ass1.assignment_type = 'E'

Line 293: FROM per_assignments_f cass

289: -- checking for grade changes
290: --
291: SELECT MAX(cass.effective_end_date+1)
292: INTO l_change_date
293: FROM per_assignments_f cass
294: WHERE cass.assignment_id = p_assignment_id
295: AND cass.grade_id <> l_grade_id
296: AND cass.effective_start_date > l_date_start
297: AND cass.effective_end_date < l_actual_termination_date;

Line 307: FROM per_assignments_f ass

303: ELSIF p_mode = 'LOCATION' THEN
304: --
305: SELECT MIN(ass.effective_start_date)
306: INTO l_date_start
307: FROM per_assignments_f ass
308: WHERE ass.location_id = l_location_id
309: AND ass.assignment_id = p_assignment_id
310: AND ass.assignment_type = 'E'
311: AND NOT EXISTS

Line 314: FROM per_assignments_f ass1

310: AND ass.assignment_type = 'E'
311: AND NOT EXISTS
312: (
313: SELECT null
314: FROM per_assignments_f ass1
315: WHERE ass1.assignment_id = ass.assignment_id
316: AND NVL(ass1.location_id,9.9)+0 =
317: NVL(ass.location_id,9.9)+0
318: AND ass1.effective_start_date =

Line 321: FROM per_assignments_f ass2

317: NVL(ass.location_id,9.9)+0
318: AND ass1.effective_start_date =
319: (
320: SELECT MAX(ass2.effective_start_date)
321: FROM per_assignments_f ass2
322: WHERE ass2.assignment_id = ass1.assignment_id
323: AND ass2.effective_start_date < ass.effective_start_date
324: )
325: AND ass1.assignment_type = 'E'

Line 334: FROM per_assignments_f cass

330: -- checking for location changes
331: --
332: SELECT MAX(cass.effective_end_date+1)
333: INTO l_change_date
334: FROM per_assignments_f cass
335: WHERE cass.assignment_id = p_assignment_id
336: AND cass.location_id <> l_location_id
337: AND cass.effective_start_date > l_date_start
338: AND cass.effective_end_date < l_actual_termination_date;