APPS.IGS_AD_VAL_SCFT dependencies on IGS_ST_GVTSEMLOAD_CA

Line 88: IGS_ST_GVTSEMLOAD_CA gslc,

84: v_cop VARCHAR2(1);
85: CURSOR c_cop IS
86: SELECT 'x'
87: FROM IGS_PS_OFR_PAT cop,
88: IGS_ST_GVTSEMLOAD_CA gslc,
89: IGS_CA_INST_REL cir
90: WHERE gslc.submission_yr = p_submission_yr AND
91: gslc.submission_number = p_submission_number AND
92: cop.course_cd = p_course_cd AND

Line 270: IGS_ST_GVTSEMLOAD_CA gslc,

266: v_cop VARCHAR2(1);
267: CURSOR c_cop IS
268: SELECT 'x'
269: FROM IGS_PS_OFR_PAT cop,
270: IGS_ST_GVTSEMLOAD_CA gslc,
271: IGS_CA_INST_REL cir
272: WHERE gslc.submission_yr = p_submission_yr AND
273: gslc.submission_number = p_submission_number AND
274: cop.course_cd = p_course_cd AND