APPS.HRI_OPL_WRKFC_EVT_ORGH dependencies on HRI_EQ_WRKFC_EVT_ORGH

Line 785: hri_eq_wrkfc_evt_orgh eq

781: ,add_months(to_date(SUBSTR(to_char(mnth.month_id), 1, 4) || '-' ||
782: SUBSTR(to_char(mnth.month_id), 6, 2), 'YYYY-MM'),
783: 1) - 1 snapshot_date
784: FROM
785: hri_eq_wrkfc_evt_orgh eq
786: ,hri_cs_orgh_ct orgh
787: ,fii_time_month mnth
788: WHERE mnth.month_id >= to_number(to_char(eq.erlst_evnt_effective_date, 'YYYYQMM'))
789: AND mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))

Line 805: hri_eq_wrkfc_evt_orgh eq

801: WHERE snp.rowid IN
802: (SELECT /*+ ORDERED */
803: snp2.rowid
804: FROM
805: hri_eq_wrkfc_evt_orgh eq
806: ,hri_cs_orgh_ct orgh
807: ,hri_mds_wrkfc_orgh_c01_ct snp2
808: WHERE eq.organization_id = snp2.sup_organztn_fk
809: AND eq.organization_id BETWEEN p_start_object_id

Line 888: DELETE FROM hri_eq_wrkfc_evt_orgh eq

884: BEGIN
885:
886: -- Remove records in event queue that have duplicate records in event queue for
887: -- an earlier refresh date
888: DELETE FROM hri_eq_wrkfc_evt_orgh eq
889: WHERE EXISTS
890: (SELECT null
891: FROM hri_eq_wrkfc_evt_orgh eq2
892: WHERE eq2.organization_id = eq.organization_id

Line 891: FROM hri_eq_wrkfc_evt_orgh eq2

887: -- an earlier refresh date
888: DELETE FROM hri_eq_wrkfc_evt_orgh eq
889: WHERE EXISTS
890: (SELECT null
891: FROM hri_eq_wrkfc_evt_orgh eq2
892: WHERE eq2.organization_id = eq.organization_id
893: AND (eq2.erlst_evnt_effective_date < eq.erlst_evnt_effective_date
894: OR (eq2.rowid < eq.rowid AND
895: eq2.erlst_evnt_effective_date = eq.erlst_evnt_effective_date)));

Line 981: ,hri_eq_wrkfc_evt_orgh eq

977: orgh.orgh_sup_organztn_fk object_id
978: ,orgh.orgh_level object_lvl
979: FROM
980: hri_cs_orgh_ct orgh
981: ,hri_eq_wrkfc_evt_orgh eq
982: WHERE orgh.orgh_relative_level = 0
983: AND orgh.orgh_sub_node_has_workers_flag = ''Y''
984: AND orgh.orgh_sup_organztn_fk = eq.organization_id
985: ORDER BY 2 DESC, 1';

Line 1038: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT_ORGH';

1034: p_table_owner => l_schema);
1035: END IF;
1036:
1037: -- Empty out workforce organization summary event queue
1038: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT_ORGH';
1039: EXECUTE IMMEDIATE(l_sql_stmt);
1040:
1041: END post_process;
1042:

Line 1089: hri_eq_wrkfc_evt_orgh eq

1085: (eq.organization_id * g_no_qtrs_to_process) +
1086: (months_between(qtr.start_date,
1087: trunc(g_dbi_start_date,'Q')) / 3) object_id
1088: FROM
1089: hri_eq_wrkfc_evt_orgh eq
1090: ,fii_time_qtr qtr
1091: WHERE qtr.end_date >= eq.erlst_evnt_effective_date
1092: AND qtr.start_date <= g_refresh_to_date
1093: ORDER BY 1