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_OPL_ASGN_EVENTS dependencies on HRI_EQ_ASGN_EVNTS

Line 400: hri_eq_asgn_evnts;

396: SELECT
397: assignment_id
398: ,erlst_evnt_effective_date
399: FROM
400: hri_eq_asgn_evnts;
401:
402: INSERT INTO hri_eq_wrkfc_mnth
403: (assignment_id
404: ,erlst_evnt_effective_date)

Line 409: hri_eq_asgn_evnts;

405: SELECT
406: assignment_id
407: ,erlst_evnt_effective_date
408: FROM
409: hri_eq_asgn_evnts;
410:
411: END IF;
412:
413: END populate_wrkfc_evt_eq;

Line 435: hri_eq_asgn_evnts eq

431: SELECT /*+ ORDERED */
432: orgh.orgh_sup_organztn_fk
433: ,GREATEST(eq.erlst_evnt_effective_date, evt.effective_change_date)
434: FROM
435: hri_eq_asgn_evnts eq
436: ,hri_mb_asgn_events_ct evt
437: ,hri_cs_orgh_ct orgh
438: WHERE eq.assignment_id = evt.assignment_id
439: AND eq.erlst_evnt_effective_date <= evt.effective_change_end_date

Line 447: hri_eq_asgn_evnts eq

443: SELECT /*+ ORDERED */
444: orgh.orgh_sup_organztn_fk
445: ,GREATEST(eq.erlst_evnt_effective_date, asg.effective_start_date)
446: FROM
447: hri_eq_asgn_evnts eq
448: ,per_all_assignments_f asg
449: ,hri_cs_orgh_ct orgh
450: WHERE eq.assignment_id = asg.assignment_id
451: AND eq.erlst_evnt_effective_date <= asg.effective_end_date

Line 480: hri_eq_asgn_evnts eq

476: suph.sup_person_id
477: ,GREATEST(eq.erlst_evnt_effective_date, evt.effective_change_date)
478: ,'ASG_EVENT_PREV'
479: FROM
480: hri_eq_asgn_evnts eq
481: ,hri_mb_asgn_events_ct evt
482: ,hri_cs_suph suph
483: WHERE eq.assignment_id = evt.assignment_id
484: AND evt.supervisor_id = suph.sub_person_id

Line 494: hri_eq_asgn_evnts eq

490: suph.sup_person_id
491: ,GREATEST(eq.erlst_evnt_effective_date, asg.effective_start_date)
492: ,'ASG_EVENT_CURR'
493: FROM
494: hri_eq_asgn_evnts eq
495: ,per_all_assignments_f asg
496: ,hri_cs_suph suph
497: WHERE eq.assignment_id = asg.assignment_id
498: AND eq.erlst_evnt_effective_date <= asg.effective_end_date

Line 533: FROM hri_eq_asgn_evnts) asg_eq

529: MERGE INTO hri_eq_asg_sup_wrfc delta_eq
530: USING (SELECT assignment_id,
531: erlst_evnt_effective_date,
532: 'ASG_EVENT' source_type
533: FROM hri_eq_asgn_evnts) asg_eq
534: ON ( delta_eq.source_type = 'ASG_EVENT'
535: AND asg_eq.assignment_id = delta_eq.source_id)
536: WHEN MATCHED THEN
537: UPDATE SET delta_eq.erlst_evnt_effective_date =

Line 627: INSERT /+ APPEND / INTO hri_eq_asgn_evnts(

623: dbg('fetched '||l_pow_event_date.count||' records for writing to events queue');
624: --
625: FORALL l_loop IN l_pow_event_asg_id.FIRST..l_pow_event_asg_id.LAST SAVE EXCEPTIONS
626: --
627: INSERT /*+ APPEND */ INTO hri_eq_asgn_evnts(
628: assignment_id,
629: erlst_evnt_effective_date
630: )
631: VALUES(

Line 659: UPDATE hri_eq_asgn_evnts

655: --
656: l_upd_asg_id := l_pow_event_asg_id(sql%bulk_exceptions(l_loop).error_index);
657: l_upd_asg_date := l_pow_event_date(sql%bulk_exceptions(l_loop).error_index);
658: --
659: UPDATE hri_eq_asgn_evnts
660: SET erlst_evnt_effective_date = least(erlst_evnt_effective_date,l_upd_asg_date)
661: WHERE assignment_id = l_upd_asg_id;
662: --
663: END LOOP;

Line 1314: FROM hri_eq_asgn_evnts eq

1310: --
1311: DELETE FROM hri_mb_asgn_events_ct evt
1312: WHERE evt.rowid IN
1313: (SELECT evt2.rowid
1314: FROM hri_eq_asgn_evnts eq
1315: , hri_mb_asgn_events_ct evt2
1316: WHERE eq.assignment_id = evt2.assignment_id
1317: AND evt2.effective_change_date >= eq.erlst_evnt_effective_date
1318: AND eq.assignment_id BETWEEN p_start_assignment_id AND p_end_assignment_id);

Line 5005: FROM hri_eq_asgn_evnts evt

5001: --
5002: p_sqlstr :=
5003: 'SELECT /*+ PARALLEL(evt, DEFAULT, DEFAULT) */
5004: evt.assignment_id object_id
5005: FROM hri_eq_asgn_evnts evt
5006: ORDER BY evt.assignment_id';
5007: --
5008: END IF;
5009: --

Line 5184: FROM hri_eq_asgn_evnts evts

5180: OPEN c_asg_to_process FOR
5181: SELECT DISTINCT
5182: evts.assignment_id assignment_id,
5183: erlst_evnt_effective_date change_date
5184: FROM hri_eq_asgn_evnts evts
5185: WHERE evts.assignment_id BETWEEN p_start_object_id and p_end_object_id;
5186: --
5187: END IF;
5188: --

Line 5415: hri_opl_event_capture.purge_queue('HRI_EQ_ASGN_EVNTS');

5411: -- even after the after full refresh. Recollecting incremental changes
5412: -- will be useless if a full refresh has been run.
5413: --
5414: dbg('Purging the events queue');
5415: hri_opl_event_capture.purge_queue('HRI_EQ_ASGN_EVNTS');
5416: --
5417: hri_bpl_conc_log.log_process_end(
5418: p_status => TRUE
5419: ,p_period_from => TRUNC(g_refresh_start_date)