APPS.IGS_EN_GEN_008 dependencies on IGS_CA_DA_INST

Line 84: igs_ca_da_inst daiv

80: IGS_CA_GEN_002.cals_clc_dt_from_dai(daiv.ci_sequence_number,
81: daiv.CAL_TYPE,
82: daiv.DT_ALIAS, daiv.sequence_number) ) ) alias_val
83: FROM igs_pe_usr_adisc_all pua,
84: igs_ca_da_inst daiv
85: WHERE daiv.cal_type = p_cal_type
86: AND daiv.ci_sequence_number = p_ci_sequence_number
87: AND daiv.dt_alias = pua.disc_dt_alias
88: AND pua.person_type = cp_person_type

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 360: FROM igs_ca_da_inst dai,

356: )
357: ) alias_val,
358: uddc.administrative_unit_status,
359: uddc.dflt_ind
360: FROM igs_ca_da_inst dai,
361: igs_ps_unit_disc_crt uddc
362: WHERE dai.cal_type = p_cal_type AND
363: dai.ci_sequence_number = p_ci_sequence_number AND
364: dai.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 2282: IGS_CA_DA_INST dai

2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2280: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2281: FROM IGS_PE_USR_ARG_ALL pua,
2282: IGS_CA_DA_INST dai
2283: WHERE pua.person_type = cp_person_type
2284: AND dai.dt_alias = pua.grad_sch_dt_alias
2285: AND dai.cal_type = p_cal_type
2286: AND dai.ci_sequence_number = p_ci_sequence_number

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 2514: FROM igs_ca_da_inst dai,igs_pe_usr_arg_all pua

2510: SELECT nvl(dai.absolute_val,
2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2513: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2514: FROM igs_ca_da_inst dai,igs_pe_usr_arg_all pua
2515: WHERE pua.person_type = cp_person_type
2516: AND dai.dt_alias = pua.grad_sch_dt_alias
2517: AND dai.cal_type = p_cal_type
2518: AND dai.ci_sequence_number = p_ci_sequence_number

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