APPS.IGS_EN_VAL_BULKRULE dependencies on IGS_CA_DA_INST_V

Line 253: v_last_date_to_invalid IGS_CA_DA_INST_V.alias_val%TYPE;

249:
250: v_counter NUMBER; -- keeps record of the number of records in the PL/SQL table
251: v_next_rec BOOLEAN; -- used to determine if the next record should be found
252: v_do_cursor_again_ind BOOLEAN;
253: v_last_date_to_invalid IGS_CA_DA_INST_V.alias_val%TYPE;
254: v_message_text VARCHAR2(2000);
255: -- Add the following one line of code. From Callista 2.0 18-May-2000
256: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
257: -- Initialise PL/SQL table to hold UNIT attempt records which

Line 321: FROM IGS_CA_DA_INST_V daiv

317: CURSOR c_daiv (
318: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
319: cp_sua_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
320: SELECT MAX(daiv.alias_val)
321: FROM IGS_CA_DA_INST_V daiv
322: WHERE daiv.cal_type = cp_sua_cal_type AND
323: daiv.ci_sequence_number = cp_sua_sequence_number AND
324: daiv.dt_alias = p_invalid_rule_cutoff_dt;
325:

Line 766: v_last_date_to_enrolled IGS_CA_DA_INST_V.alias_val%TYPE;

762: DECLARE
763: v_counter NUMBER; -- keeps record of the number of records in the PL/SQL table
764: v_next_rec BOOLEAN; -- used to determine if the next record should be found
765: v_do_cursor_again_ind BOOLEAN;
766: v_last_date_to_enrolled IGS_CA_DA_INST_V.alias_val%TYPE;
767: v_validation_error BOOLEAN;
768: v_message_text VARCHAR2(2000);
769: v_validation_message_name VARCHAR2(30);
770: v_attendance_types VARCHAR2(100);

Line 848: FROM IGS_CA_DA_INST_V daiv

844: CURSOR c_daiv (
845: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
846: cp_sua_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE) IS
847: SELECT MAX(daiv.alias_val)
848: FROM IGS_CA_DA_INST_V daiv
849: WHERE daiv.cal_type = cp_sua_cal_type AND
850: daiv.ci_sequence_number = cp_sua_sequence_number AND
851: daiv.dt_alias = p_enrolled_rule_cutoff_dt;
852: