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_WRKFC_SPRTN dependencies on PER_ALL_ASSIGNMENTS_F

Line 320: per_all_assignments_f asg

316: ,DECODE(SIGN(pps.final_process_date - sysdate),
317: 1, to_date(null),
318: pps.final_process_date)
319: FROM
320: per_all_assignments_f asg
321: ,per_periods_of_service pps
322: WHERE asg.person_id = pps.person_id
323: AND asg.period_of_service_id = pps.period_of_service_id
324: AND asg.effective_start_date =

Line 326: FROM per_all_assignments_f asg2

322: WHERE asg.person_id = pps.person_id
323: AND asg.period_of_service_id = pps.period_of_service_id
324: AND asg.effective_start_date =
325: (SELECT MAX(asg2.effective_start_date)
326: FROM per_all_assignments_f asg2
327: WHERE asg2.assignment_id = asg.assignment_id)
328: AND NOT EXISTS (SELECT null
329: FROM hri_edw_period_of_service hps
330: WHERE hps.period_of_service_id = pps.period_of_service_id

Line 340: FROM per_all_assignments_f asg

336: -- that exist in the table hri_edw_period_of_service
337: UPDATE hri_edw_period_of_service hps
338: SET notified_trmntn_primary_flag =
339: (SELECT asg.primary_flag
340: FROM per_all_assignments_f asg
341: WHERE hps.past_notified_date IS NOT NULL
342: AND hps.assignment_id = asg.assignment_id
343: AND hps.past_notified_date
344: BETWEEN asg.effective_start_date AND asg.effective_end_date);

Line 353: FROM per_all_assignments_f asg

349: -- that exist in the table hri_edw_period_of_service
350: UPDATE hri_edw_period_of_service hps
351: SET accepted_trmntn_primary_flag =
352: (SELECT asg.primary_flag
353: FROM per_all_assignments_f asg
354: WHERE hps.past_accepted_date IS NOT NULL
355: AND hps.assignment_id = asg.assignment_id
356: AND hps.past_accepted_date
357: BETWEEN asg.effective_start_date AND asg.effective_end_date);

Line 366: FROM per_all_assignments_f asg

362: -- that exist in the table hri_edw_period_of_service
363: UPDATE hri_edw_period_of_service hps
364: SET projected_trmntn_primary_flag =
365: (SELECT asg.primary_flag
366: FROM per_all_assignments_f asg
367: WHERE hps.effective_projected_date IS NOT NULL
368: AND hps.assignment_id = asg.assignment_id
369: AND LEAST(hps.effective_projected_date, SYSDATE)
370: BETWEEN asg.effective_start_date AND asg.effective_end_date);

Line 379: FROM per_all_assignments_f asg

375: -- that exist in the table hri_edw_period_of_service
376: UPDATE hri_edw_period_of_service hps
377: SET actual_trmntn_primary_flag =
378: (SELECT asg.primary_flag
379: FROM per_all_assignments_f asg
380: WHERE hps.past_actual_date IS NOT NULL
381: AND hps.assignment_id = asg.assignment_id
382: AND hps.past_actual_date
383: BETWEEN asg.effective_start_date AND asg.effective_end_date);

Line 392: FROM per_all_assignments_f asg

388: -- that exist in the table hri_edw_period_of_service
389: UPDATE hri_edw_period_of_service hps
390: SET final_process_primary_flag =
391: (SELECT asg.primary_flag
392: FROM per_all_assignments_f asg
393: WHERE hps.past_final_date IS NOT NULL
394: AND hps.assignment_id = asg.assignment_id
395: AND hps.past_final_date
396: BETWEEN asg.effective_start_date AND asg.effective_end_date);

Line 406: FROM per_all_assignments_f asg

402: -- hri_edw_period_of_service
403: UPDATE hri_edw_period_of_service hps
404: SET latest_stage_primary_flag =
405: (SELECT asg.primary_flag
406: FROM per_all_assignments_f asg
407: WHERE hps.assignment_id = asg.assignment_id
408: AND NVL(hps.past_final_date,
409: NVL(hps.past_actual_date,
410: NVL(hps.effective_projected_date,