APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_APPL_LTR

Line 196: FROM IGS_AD_APPL_LTR aal

192: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
193: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
194: IS
195: SELECT 'x'
196: FROM IGS_AD_APPL_LTR aal
197: WHERE aal.person_id = cp_person_id AND
198: aal.admission_appl_number = cp_admission_appl_number;
199: CURSOR c_aa (
200: cp_person_id IGS_AD_APPL.person_id%TYPE,

Line 463: FROM IGS_AD_APPL_LTR

459: -- Validate delete of an IGS_AD_PS_APPL_INST record
460: DECLARE
461: CURSOR c_aal IS
462: SELECT 'x'
463: FROM IGS_AD_APPL_LTR
464: WHERE person_id = p_person_id AND
465: admission_appl_number = p_admission_appl_number;
466: CURSOR c_aas IS
467: SELECT 'x'