APPS.HRI_OPL_WRKFC_EVENTS dependencies on HRI_EQ_WRKFC_EVT

Line 2202: hri_eq_wrkfc_evt eq

2198: ,evt.business_group_id adt_business_group_id
2199: ,evt.performance_review_id adt_perf_review_id
2200: ,eq.erlst_evnt_effective_date adt_event_date
2201: FROM
2202: hri_eq_wrkfc_evt eq
2203: ,hri_mb_asgn_events_ct evt
2204: WHERE evt.assignment_id = eq.assignment_id
2205: AND evt.effective_change_end_date >= eq.erlst_evnt_effective_date - 1
2206: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id

Line 2240: hri_eq_wrkfc_evt eq

2236: WHERE evt.rowid IN
2237: (SELECT /*+ ORDERED */
2238: evt2.rowid
2239: FROM
2240: hri_eq_wrkfc_evt eq
2241: ,hri_mb_wrkfc_evt_ct evt2
2242: WHERE evt2.asg_assgnmnt_fk = eq.assignment_id
2243: AND evt2.time_day_evt_fk >= eq.erlst_evnt_effective_date
2244: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id);

Line 2250: FROM hri_eq_wrkfc_evt eq

2246: -- End date records overlapping with event date
2247: UPDATE hri_mb_wrkfc_evt_ct evt
2248: SET evt.time_day_evt_end_fk =
2249: (SELECT eq.erlst_evnt_effective_date - 1
2250: FROM hri_eq_wrkfc_evt eq
2251: WHERE evt.asg_assgnmnt_fk = eq.assignment_id)
2252: WHERE evt.rowid IN
2253: (SELECT /*+ ORDERED */
2254: evt2.rowid

Line 2256: hri_eq_wrkfc_evt eq2

2252: WHERE evt.rowid IN
2253: (SELECT /*+ ORDERED */
2254: evt2.rowid
2255: FROM
2256: hri_eq_wrkfc_evt eq2
2257: ,hri_mb_wrkfc_evt_ct evt2
2258: WHERE evt2.asg_assgnmnt_fk = eq2.assignment_id
2259: AND eq2.erlst_evnt_effective_date BETWEEN evt2.time_day_evt_fk
2260: AND evt2.time_day_evt_end_fk

Line 2293: DELETE FROM hri_eq_wrkfc_evt

2289: p_end_asg_id IN NUMBER) IS
2290:
2291: BEGIN
2292:
2293: DELETE FROM hri_eq_wrkfc_evt
2294: WHERE assignment_id BETWEEN p_start_asg_id AND p_end_asg_id;
2295:
2296: DELETE FROM hri_eq_wrkfc_mnth
2297: WHERE assignment_id BETWEEN p_start_asg_id AND p_end_asg_id;

Line 2379: DELETE FROM hri_eq_wrkfc_evt eq

2375: BEGIN
2376:
2377: -- Remove records in event queue that have duplicate records in event queue for
2378: -- an earlier refresh date
2379: DELETE FROM hri_eq_wrkfc_evt eq
2380: WHERE EXISTS
2381: (SELECT null
2382: FROM hri_eq_wrkfc_evt eq2
2383: WHERE eq2.assignment_id = eq.assignment_id

Line 2382: FROM hri_eq_wrkfc_evt eq2

2378: -- an earlier refresh date
2379: DELETE FROM hri_eq_wrkfc_evt eq
2380: WHERE EXISTS
2381: (SELECT null
2382: FROM hri_eq_wrkfc_evt eq2
2383: WHERE eq2.assignment_id = eq.assignment_id
2384: AND (eq2.erlst_evnt_effective_date < eq.erlst_evnt_effective_date
2385: OR (eq2.rowid < eq.rowid AND
2386: eq2.erlst_evnt_effective_date = eq.erlst_evnt_effective_date)));

Line 2549: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT';

2545: p_table_owner => l_schema);
2546: END IF;
2547:
2548: -- Empty out absence summary event queue
2549: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_EQ_WRKFC_EVT';
2550: -- EXECUTE IMMEDIATE(l_sql_stmt);
2551:
2552: END post_process;
2553: