APPS.HRI_OPL_WRKFC_EVENTS dependencies on HRI_EQ_WRKFC_MNTH

Line 852: hri_eq_wrkfc_mnth eq

848: ,wevt.contingent_ind
849: ,wevt.adt_pow_band
850: ,eq.erlst_evnt_effective_date adt_event_date
851: FROM
852: hri_eq_wrkfc_mnth eq
853: ,hri_mb_wrkfc_evt_ct wevt
854: ,fii_time_month mnth
855: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
856: AND mnth.end_date BETWEEN wevt.time_day_evt_fk

Line 1064: hri_eq_wrkfc_mnth eq

1060: ELSE 0
1061: END last_month_in_year_ind
1062: ,0 zero_row_ind
1063: FROM
1064: hri_eq_wrkfc_mnth eq
1065: ,hri_mb_wrkfc_evt_ct wevt
1066: ,fii_time_month mnth
1067: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1068: AND mnth.end_date >= ADD_MONTHS(eq.erlst_evnt_effective_date, -1)

Line 1138: hri_eq_wrkfc_mnth eq

1134: ELSE 0
1135: END last_month_in_year_ind
1136: ,1 zero_row_ind
1137: FROM
1138: hri_eq_wrkfc_mnth eq
1139: ,hri_mb_wrkfc_evt_ct wevt
1140: ,fii_time_month mnth
1141: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1142: AND mnth.end_date BETWEEN wevt.time_day_evt_fk

Line 1229: hri_eq_wrkfc_mnth eq

1225: WHERE snp.rowid IN
1226: (SELECT /*+ ORDERED */
1227: snp2.rowid
1228: FROM
1229: hri_eq_wrkfc_mnth eq
1230: ,hri_mds_wrkfc_mnth_ct snp2
1231: WHERE eq.assignment_id = snp2.asg_assgnmnt_fk
1232: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
1233: AND snp2.time_month_snp_fk >=

Line 2296: DELETE FROM hri_eq_wrkfc_mnth

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;
2298:
2299: END delete_eq_incr;
2300:

Line 2390: DELETE FROM hri_eq_wrkfc_mnth eq

2386: eq2.erlst_evnt_effective_date = eq.erlst_evnt_effective_date)));
2387:
2388: -- Remove records in event queue that have duplicate records in event queue for
2389: -- an earlier refresh date
2390: DELETE FROM hri_eq_wrkfc_mnth eq
2391: WHERE EXISTS
2392: (SELECT null
2393: FROM hri_eq_wrkfc_mnth eq2
2394: WHERE eq2.assignment_id = eq.assignment_id

Line 2393: FROM hri_eq_wrkfc_mnth eq2

2389: -- an earlier refresh date
2390: DELETE FROM hri_eq_wrkfc_mnth eq
2391: WHERE EXISTS
2392: (SELECT null
2393: FROM hri_eq_wrkfc_mnth eq2
2394: WHERE eq2.assignment_id = eq.assignment_id
2395: AND (eq2.erlst_evnt_effective_date < eq.erlst_evnt_effective_date
2396: OR (eq2.rowid < eq.rowid AND
2397: eq2.erlst_evnt_effective_date = eq.erlst_evnt_effective_date)));

Line 2491: FROM hri_eq_wrkfc_mnth

2487: -- Set the SQL statement for the incremental range
2488: p_sqlstr :=
2489: 'SELECT
2490: assignment_id object_id
2491: FROM hri_eq_wrkfc_mnth
2492: ORDER BY assignment_id';
2493:
2494: END IF;
2495:

Line 2588: FROM hri_eq_wrkfc_mnth

2584: ,CEIL(ROWNUM / 20) chunk_no
2585: FROM
2586: (SELECT
2587: assignment_id
2588: FROM hri_eq_wrkfc_mnth
2589: ORDER BY assignment_id
2590: ) tab
2591: ) chunks
2592: GROUP BY