APPS.IGS_EN_GEN_008 dependencies on IGS_CA_DA_INST_V

Line 106: igs_ca_da_inst_v daiv

102: CURSOR cur_unit_disc_crt
103: IS
104: SELECT daiv.alias_val
105: FROM igs_ps_unit_disc_crt uddc,
106: igs_ca_da_inst_v daiv
107: WHERE uddc.delete_ind = 'N'
108: AND daiv.cal_type = p_cal_type
109: AND daiv.ci_sequence_number = p_ci_sequence_number
110: AND daiv.dt_alias = uddc.unit_discont_dt_alias

Line 370: l_v_alias_val igs_ca_da_inst_v.alias_val%TYPE;

366:
367: -- Rowtype Variables
368: l_cur_unit_usec_disc cur_unit_usec_disc%ROWTYPE;
369: l_cur_inst_date_aliases cur_inst_date_aliases%ROWTYPE;
370: l_v_alias_val igs_ca_da_inst_v.alias_val%TYPE;
371: l_v_administrative_unit_status igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
372: l_v_return_value igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
373: l_v_admin_unit_status_str VARCHAR2(2000);
374: l_b_dflt_admin_unit_found BOOLEAN;

Line 730: FROM igs_ca_da_inst_v

726: -- at the institutional level for the logged on person and for the cal type, sequence number passed
727: CURSOR cur_dai_v( cp_dt_alias igs_en_cal_conf.variation_cutoff_dt_alias%TYPE)
728: IS
729: SELECT alias_val
730: FROM igs_ca_da_inst_v
731: WHERE cal_type = p_cal_type
732: AND ci_sequence_number = p_ci_sequence_number
733: AND dt_alias = cp_dt_alias
734: ORDER BY alias_val DESC;

Line 2304: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc

2300: -- Cursor for getting different grading schemas defined at the Institutional Level
2301: CURSOR cur_en_cal_conf
2302: IS
2303: SELECT dai.alias_val alias_val
2304: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc
2305: WHERE dai.cal_type = p_cal_type
2306: AND dai.ci_sequence_number = p_ci_sequence_number
2307: AND dai.dt_alias = ecc.grading_schema_dt_alias
2308: AND ecc.s_control_num =1

Line 2535: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc

2531: --Check if deadline has passed for cp change at institution level
2532: CURSOR cur_en_cal_conf
2533: IS
2534: SELECT dai.alias_val alias_val
2535: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc
2536: WHERE dai.cal_type = p_cal_type
2537: AND dai.ci_sequence_number = p_ci_sequence_number
2538: AND dai.dt_alias = ecc.grading_schema_dt_alias
2539: AND ecc.s_control_num =1