APPS.IGS_ST_VAL_GSC dependencies on IGS_EN_ST_SPSHT_CTL

Line 13: v_delete_snapshot_ind IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind%TYPE;

9: p_message_name OUT NOCOPY VARCHAR2 )
10: RETURN BOOLEAN AS
11: BEGIN
12: DECLARE
13: v_delete_snapshot_ind IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind%TYPE;
14: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
15: CURSOR c_essc(
16: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS
17: SELECT essc.delete_snapshot_ind

Line 18: FROM IGS_EN_ST_SPSHT_CTL essc

14: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
15: CURSOR c_essc(
16: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS
17: SELECT essc.delete_snapshot_ind
18: FROM IGS_EN_ST_SPSHT_CTL essc
19: WHERE essc.snapshot_dt_time = cp_snapshot_dt_time;
20: CURSOR c_gsc(
21: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE,
22: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE) IS