APPS.IGS_AD_VAL_AAL dependencies on IGS_AD_APPL_LTR

Line 116: FROM IGS_AD_APPL_LTR

112: -- with the passed correspondence type and checks if it has been sent.
113: DECLARE
114: CURSOR c_aal IS
115: SELECT sequence_number
116: FROM IGS_AD_APPL_LTR
117: WHERE person_id = p_person_id AND
118: admission_appl_number = p_admission_appl_number AND
119: correspondence_type = p_correspondence_type;
120: v_sequence_number IGS_AD_APPL_LTR.sequence_number%TYPE;

Line 120: v_sequence_number IGS_AD_APPL_LTR.sequence_number%TYPE;

116: FROM IGS_AD_APPL_LTR
117: WHERE person_id = p_person_id AND
118: admission_appl_number = p_admission_appl_number AND
119: correspondence_type = p_correspondence_type;
120: v_sequence_number IGS_AD_APPL_LTR.sequence_number%TYPE;
121: BEGIN
122: -- Set the default message number
123: p_message_name := null;
124: FOR v_aal_rec IN c_aal LOOP