APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_APPL_LTR_PHR

Line 2909: IGS_AD_APPL_LTR_PHR aalp

2905: cst_error CONSTANT VARCHAR2(1) := 'E';
2906: CURSOR c_seq_no IS
2907: SELECT aal.sequence_number
2908: FROM IGS_AD_APPL_LTR aal,
2909: IGS_AD_APPL_LTR_PHR aalp
2910: WHERE aalp.person_id = p_person_id AND
2911: aalp.admission_appl_number = p_admission_appl_number AND
2912: aalp.correspondence_type = 'OUTCOME-LT' AND
2913: aal.person_id = aalp.person_id AND