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.HRI_EDW_FCT_WRK_ACTVTY dependencies on PER_ALL_ASSIGNMENTS_F

Line 88: per_all_assignments_f asg1

84: /* organization change occurred */
85: CURSOR last_org_cur IS
86: SELECT MAX(asg2.effective_start_date)
87: FROM
88: per_all_assignments_f asg1
89: ,per_all_assignments_f asg2
90: WHERE
91: asg1.assignment_id = p_assignment_id
92: AND asg2.assignment_id = p_assignment_id

Line 89: ,per_all_assignments_f asg2

85: CURSOR last_org_cur IS
86: SELECT MAX(asg2.effective_start_date)
87: FROM
88: per_all_assignments_f asg1
89: ,per_all_assignments_f asg2
90: WHERE
91: asg1.assignment_id = p_assignment_id
92: AND asg2.assignment_id = p_assignment_id
93: AND asg1.effective_end_date + 1 = asg2.effective_start_date

Line 100: FROM per_all_assignments_f asg

96:
97: /* Get assignment creation date */
98: CURSOR asg_start_cur IS
99: SELECT MIN(asg.effective_start_date)
100: FROM per_all_assignments_f asg
101: WHERE asg.assignment_id = p_assignment_id
102: AND asg.assignment_type = 'E';
103:
104: BEGIN

Line 146: per_all_assignments_f asg1

142: /* job change occurred */
143: CURSOR last_job_cur IS
144: SELECT MAX(asg2.effective_start_date)
145: FROM
146: per_all_assignments_f asg1
147: ,per_all_assignments_f asg2
148: WHERE
149: asg1.assignment_id = p_assignment_id
150: AND asg2.assignment_id = p_assignment_id

Line 147: ,per_all_assignments_f asg2

143: CURSOR last_job_cur IS
144: SELECT MAX(asg2.effective_start_date)
145: FROM
146: per_all_assignments_f asg1
147: ,per_all_assignments_f asg2
148: WHERE
149: asg1.assignment_id = p_assignment_id
150: AND asg2.assignment_id = p_assignment_id
151: AND asg1.effective_end_date + 1 = asg2.effective_start_date

Line 158: FROM per_all_assignments_f asg

154:
155: /* Get assignment creation date */
156: CURSOR asg_start_cur IS
157: SELECT MIN(asg.effective_start_date)
158: FROM per_all_assignments_f asg
159: WHERE asg.assignment_id = p_assignment_id
160: AND asg.assignment_type = 'E';
161:
162: BEGIN

Line 204: per_all_assignments_f asg1

200: /* position change occurred */
201: CURSOR last_pos_cur IS
202: SELECT MAX(asg2.effective_start_date)
203: FROM
204: per_all_assignments_f asg1
205: ,per_all_assignments_f asg2
206: WHERE
207: asg1.assignment_id = p_assignment_id
208: AND asg2.assignment_id = p_assignment_id

Line 205: ,per_all_assignments_f asg2

201: CURSOR last_pos_cur IS
202: SELECT MAX(asg2.effective_start_date)
203: FROM
204: per_all_assignments_f asg1
205: ,per_all_assignments_f asg2
206: WHERE
207: asg1.assignment_id = p_assignment_id
208: AND asg2.assignment_id = p_assignment_id
209: AND asg1.effective_end_date + 1 = asg2.effective_start_date

Line 216: FROM per_all_assignments_f asg

212:
213: /* Get assignment creation date */
214: CURSOR asg_start_cur IS
215: SELECT MIN(asg.effective_start_date)
216: FROM per_all_assignments_f asg
217: WHERE asg.assignment_id = p_assignment_id
218: AND asg.assignment_type = 'E';
219:
220: BEGIN

Line 262: per_all_assignments_f asg1

258: /* grade change occurred */
259: CURSOR last_grd_cur IS
260: SELECT MAX(asg2.effective_start_date)
261: FROM
262: per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: WHERE
265: asg1.assignment_id = p_assignment_id
266: AND asg2.assignment_id = p_assignment_id

Line 263: ,per_all_assignments_f asg2

259: CURSOR last_grd_cur IS
260: SELECT MAX(asg2.effective_start_date)
261: FROM
262: per_all_assignments_f asg1
263: ,per_all_assignments_f asg2
264: WHERE
265: asg1.assignment_id = p_assignment_id
266: AND asg2.assignment_id = p_assignment_id
267: AND asg1.effective_end_date + 1 = asg2.effective_start_date

Line 274: FROM per_all_assignments_f asg

270:
271: /* Get assignment creation date */
272: CURSOR asg_start_cur IS
273: SELECT MIN(asg.effective_start_date)
274: FROM per_all_assignments_f asg
275: WHERE asg.assignment_id = p_assignment_id
276: AND asg.assignment_type = 'E';
277:
278: BEGIN

Line 320: per_all_assignments_f asg1

316: /* geography change occurred */
317: CURSOR last_geog_cur IS
318: SELECT MAX(asg2.effective_start_date)
319: FROM
320: per_all_assignments_f asg1
321: ,per_all_assignments_f asg2
322: WHERE
323: asg1.assignment_id = p_assignment_id
324: AND asg2.assignment_id = p_assignment_id

Line 321: ,per_all_assignments_f asg2

317: CURSOR last_geog_cur IS
318: SELECT MAX(asg2.effective_start_date)
319: FROM
320: per_all_assignments_f asg1
321: ,per_all_assignments_f asg2
322: WHERE
323: asg1.assignment_id = p_assignment_id
324: AND asg2.assignment_id = p_assignment_id
325: AND asg1.effective_end_date + 1 = asg2.effective_start_date

Line 332: FROM per_all_assignments_f asg

328:
329: /* Get assignment creation date */
330: CURSOR asg_start_cur IS
331: SELECT MIN(asg.effective_start_date)
332: FROM per_all_assignments_f asg
333: WHERE asg.assignment_id = p_assignment_id
334: AND asg.assignment_type = 'E';
335:
336: BEGIN