DBA Data[Home] [Help]

APPS.IGS_AD_INS_ADMPERD dependencies on IGS_PS_OFR_PAT

Line 227: FROM IGS_PS_OFR_PAT cop,

223: cp_course_cd IGS_AD_PRD_PS_OF_OPT.course_cd%TYPE,
224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS
226: SELECT 'x'
227: FROM IGS_PS_OFR_PAT cop,
228: IGS_CA_INST_REL cir
229: WHERE cir.sub_cal_type = p_adm_cal_type AND
230: cir.sub_ci_sequence_number = p_new_adm_ci_sequence_number AND
231: cop.course_cd = cp_course_cd AND