APPS.IGS_ST_VAL_ESSC dependencies on IGS_ST_GVT_SPSHT_CTL

Line 17: FROM IGS_ST_GVT_SPSHT_CTL gsc

13: DECLARE
14: CURSOR c_govt_snapshot_ctl(
15: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE) IS
16: SELECT gsc.submission_yr
17: FROM IGS_ST_GVT_SPSHT_CTL gsc
18: WHERE gsc.ess_snapshot_dt_time = cp_snapshot_dt_time;
19: BEGIN
20: -- This module validates the setting of the
21: -- IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind.