APPS.HRI_BPL_PERIOD_OF_WORK dependencies on HRI_CS_POW_BAND_CT

Line 675: FROM hri_cs_pow_band_ct powb

671: RETURN NUMBER IS
672: --
673: cursor c_pow_band IS
674: SELECT pow_band_sk_pk
675: FROM hri_cs_pow_band_ct powb
676: WHERE powb.wkth_wktyp_sk_fk = decode(p_assignment_type,'E','EMP','CWK')
677: AND powb.band_sequence = p_band_number;
678: --
679: l_pow_band_sk_fk NUMBER;