APPS.HRI_OPL_ASGN_EVENTS dependencies on HRI_CS_POW_BAND_CT

Line 575: hri_cs_pow_band_ct powb

571: CURSOR c_pow_changes IS
572: SELECT DISTINCT asgn.assignment_id,
573: add_months(pow_start_date_adj, band_range_high) first_event
574: FROM hri_mb_Asgn_events_ct asgn,
575: hri_cs_pow_band_ct powb
576: WHERE asgn.pow_band_sk_fk = powb.pow_band_sk_pk
577: AND powb.band_range_high is not null
578: AND asgn.worker_term_ind = 0
579: AND g_refresh_start_date <= asgn.effective_change_end_date