DBA Data[Home] [Help]

APPS.IGS_AD_INS_ADMPERD dependencies on IGS_CA_INST_REL

Line 66: FROM IGS_CA_INST_REL cir,

62: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
63: SELECT ci.cal_type,
64: ci.sequence_number,
65: ci.prior_ci_sequence_number
66: FROM IGS_CA_INST_REL cir,
67: IGS_CA_INST ci,
68: IGS_CA_TYPE cat
69: WHERE cat.cal_type = ci.cal_type AND
70: cat.s_cal_cat = cst_admission AND

Line 228: IGS_CA_INST_REL cir

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
232: cop.version_number = cp_version_number AND