DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_CA_DA_INST_V

Line 1727: FROM igs_ca_da_inst_v dai,igs_pe_usr_arg_all pua

1723: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE,
1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1725: IS
1726: SELECT dai.alias_val alias_val
1727: FROM igs_ca_da_inst_v dai,igs_pe_usr_arg_all pua
1728: WHERE pua.person_type = cp_person_type
1729: AND dai.dt_alias = pua.grad_sch_dt_alias
1730: AND dai.cal_type = cp_cal_type
1731: AND dai.ci_sequence_number = cp_ci_sequence_number

Line 1747: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc

1743: --Check if deadline has passed for cp change at institution level
1744: CURSOR cur_en_cal_conf(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1745: IS
1746: SELECT dai.alias_val alias_val
1747: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc
1748: WHERE dai.cal_type = cp_cal_type
1749: AND dai.ci_sequence_number = cp_ci_sequence_number
1750: AND dai.dt_alias = ecc.grading_schema_dt_alias
1751: AND ecc.s_control_num =1