APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_CA_DA_INST_V

Line 977: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS

973: ecpd.enr_method_type = ecpe.enr_method_type AND
974: ecpd.s_student_comm_type = ecpe.s_student_comm_type AND
975: ecpd.config_min_cp_valdn <> 'NONE';
976:
977: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS
978: SELECT MIN(di.alias_val)
979: FROM igs_ca_da_inst_v di
980: WHERE di.cal_type = p_load_calendar_type AND
981: di.ci_sequence_number = p_load_cal_sequence_number AND

Line 979: FROM igs_ca_da_inst_v di

975: ecpd.config_min_cp_valdn <> 'NONE';
976:
977: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS
978: SELECT MIN(di.alias_val)
979: FROM igs_ca_da_inst_v di
980: WHERE di.cal_type = p_load_calendar_type AND
981: di.ci_sequence_number = p_load_cal_sequence_number AND
982: di.dt_alias = l_p_date_alias ;
983:

Line 1009: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;

1005: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;
1006: l_rule_message igs_ru_item.value%TYPE;
1007: -- Below two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1008:
1009: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;
1010:
1011: -- Variables
1012: l_return_value BOOLEAN;
1013: l_effective_date DATE;

Line 1336: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS

1332: -- cursor for getting all the program offering option of all the active program attempts
1333: -- modified the WHERE clause to add condition course_cd = p_course_cd and removed course_attempt_status condition.
1334:
1335: -- Cursor to fetch the Date Alias value.
1336: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS
1337: SELECT MIN(di.alias_val)
1338: FROM igs_ca_da_inst_v di
1339: WHERE di.cal_type = p_load_calendar_type AND
1340: di.ci_sequence_number = p_load_cal_sequence_number AND

Line 1338: FROM igs_ca_da_inst_v di

1334:
1335: -- Cursor to fetch the Date Alias value.
1336: CURSOR cur_get_alias_val( l_p_date_alias igs_ca_da_inst_v.dt_alias%TYPE ) IS
1337: SELECT MIN(di.alias_val)
1338: FROM igs_ca_da_inst_v di
1339: WHERE di.cal_type = p_load_calendar_type AND
1340: di.ci_sequence_number = p_load_cal_sequence_number AND
1341: di.dt_alias = l_p_date_alias ;
1342:

Line 1384: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;

1380: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1381: l_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE; -- should be NUMBER(6,3) Instead of NUMBER(5,3)
1382: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1383: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1384: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;
1385:
1386: -- Variables
1387: l_return_value BOOLEAN;
1388: l_message_name VARCHAR2(30); -- As returned from the function igs_en_val_sca.enrp_val_coo_att