APPS.IGS_ST_VAL_GSE dependencies on IGS_ST_GVT_SPSHT_CTL
Line 16: FROM IGS_ST_GVT_SPSHT_CTL gsc
12: DECLARE
13: v_gsc_count NUMBER;
14: CURSOR c_gsc IS
15: SELECT count(*) 16: FROM IGS_ST_GVT_SPSHT_CTL gsc 17: WHERE gsc.submission_yr = p_submission_yr AND
18: gsc.submission_number = p_submission_number AND
19: gsc.completion_dt IS NOT NULL;
20: BEGIN