APPS.IGS_AD_VAL_SCFT dependencies on IGS_CA_INST_REL

Line 89: IGS_CA_INST_REL cir

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
93: cop.version_number = p_crv_version_number AND

Line 271: IGS_CA_INST_REL cir

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
275: cop.version_number = p_crv_version_number AND