APPS.HRI_OPL_WRKFC_EVT_MGRH dependencies on HRI_EQ_WRKFC_EVT_MGRH

Line 804: hri_eq_wrkfc_evt_mgrh eq

800: SELECT DISTINCT
801: mgr.mgrs_person_fk manager_id
802: ,mnth.end_date snapshot_date
803: FROM
804: hri_eq_wrkfc_evt_mgrh eq
805: ,hri_cs_mngrsc_ct mgr
806: ,hri_cl_wkr_sup_status_ct stt
807: ,(SELECT
808: month.month_id

Line 840: hri_eq_wrkfc_evt_mgrh eq

836: WHERE snp.rowid IN
837: (SELECT /*+ ORDERED */
838: snp2.rowid
839: FROM
840: hri_eq_wrkfc_evt_mgrh eq
841: ,hri_cs_mngrsc_ct mgr
842: ,hri_mds_wrkfc_mgrh_c01_ct snp2
843: WHERE eq.sup_person_id = snp2.sup_person_fk
844: AND eq.sup_person_id = mgr.mgrs_person_fk

Line 921: DELETE FROM hri_eq_wrkfc_evt_mgrh eq

917: BEGIN
918:
919: -- Remove records in event queue that have duplicate records in event queue for
920: -- an earlier refresh date
921: DELETE FROM hri_eq_wrkfc_evt_mgrh eq
922: WHERE EXISTS
923: (SELECT null
924: FROM hri_eq_wrkfc_evt_mgrh eq2
925: WHERE eq2.sup_person_id = eq.sup_person_id

Line 924: FROM hri_eq_wrkfc_evt_mgrh eq2

920: -- an earlier refresh date
921: DELETE FROM hri_eq_wrkfc_evt_mgrh eq
922: WHERE EXISTS
923: (SELECT null
924: FROM hri_eq_wrkfc_evt_mgrh eq2
925: WHERE eq2.sup_person_id = eq.sup_person_id
926: AND (eq2.erlst_evnt_effective_date < eq.erlst_evnt_effective_date
927: OR (eq2.rowid < eq.rowid AND
928: eq2.erlst_evnt_effective_date = eq.erlst_evnt_effective_date)));

Line 1016: hri_eq_wrkfc_evt_mgrh eq

1012: 'SELECT DISTINCT
1013: mgr.mgrs_person_fk object_id
1014: ,mgr.mgrs_level object_lvl
1015: FROM
1016: hri_eq_wrkfc_evt_mgrh eq
1017: ,hri_cs_mngrsc_ct mgr
1018: WHERE eq.sup_person_id = mgr.mgrs_person_fk
1019: AND mgr.mgrs_date_end >= eq.erlst_evnt_effective_date
1020: AND mgr.mgrs_date_end >= hri_bpl_parameter.get_bis_global_start_date

Line 1077: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT_MGRH';

1073:
1074: END IF;
1075:
1076: -- Empty out workforce manager summary event queue
1077: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT_MGRH';
1078: EXECUTE IMMEDIATE(l_sql_stmt);
1079:
1080: END post_process;
1081:

Line 1127: hri_eq_wrkfc_evt_mgrh eq

1123: (mgr.person_id * g_no_qtrs_to_process) +
1124: (months_between(qtr.start_date,
1125: trunc(g_dbi_start_date,'Q')) / 3) object_id
1126: FROM
1127: hri_eq_wrkfc_evt_mgrh eq
1128: ,hri_cl_wkr_sup_status_ct mgr
1129: ,fii_time_qtr qtr
1130: WHERE eq.sup_person_id = mgr.person_id
1131: AND qtr.end_date >= eq.erlst_evnt_effective_date