APPS.IGS_CA_VAL_QLITY dependencies on IGS_AD_PERD_AD_CAT

Line 880: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,

876: cir.sub_ci_sequence_number = cp_sub_sequence_number AND
877: cat.S_CAL_CAT = cst_teaching AND
878: cir.sup_cal_type = cat.CAL_TYPE;
879: CURSOR c_aal (
880: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
881: cp_adm_ci_sequence_number
882: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
883: SELECT 'x'
884: FROM IGS_AD_PERD_AD_CAT apac

Line 882: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS

878: cir.sup_cal_type = cat.CAL_TYPE;
879: CURSOR c_aal (
880: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
881: cp_adm_ci_sequence_number
882: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
883: SELECT 'x'
884: FROM IGS_AD_PERD_AD_CAT apac
885: WHERE apac.adm_cal_type = cp_adm_cal_type AND
886: apac.adm_ci_sequence_number = cp_adm_ci_sequence_number;

Line 884: FROM IGS_AD_PERD_AD_CAT apac

880: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
881: cp_adm_ci_sequence_number
882: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
883: SELECT 'x'
884: FROM IGS_AD_PERD_AD_CAT apac
885: WHERE apac.adm_cal_type = cp_adm_cal_type AND
886: apac.adm_ci_sequence_number = cp_adm_ci_sequence_number;
887: CURSOR c_daiv_1 (
888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,