APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_APPL_LTR

Line 2152: FROM IGS_AD_APPL_LTR aal

2148: v_prpsd_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2149: v_ca_sequence_number NUMBER;
2150: CURSOR c_aal IS
2151: SELECT 'x'
2152: FROM IGS_AD_APPL_LTR aal
2153: WHERE aal.person_id = p_person_id AND
2154: aal.admission_appl_number = p_admission_appl_number AND
2155: aal.correspondence_type = cst_outcome_lt;
2156: CURSOR c_acai_aos IS

Line 2902: v_aal_seq_no IGS_AD_APPL_LTR.sequence_number%TYPE;

2898: -- On update of the admission outcome status warn if outcome letter
2899: -- correspondence is yet to be issued and phrases relating to the old status
2900: -- are attached
2901: DECLARE
2902: v_aal_seq_no IGS_AD_APPL_LTR.sequence_number%TYPE;
2903: v_sent_dt DATE;
2904: cst_warn CONSTANT VARCHAR2(1) := 'W';
2905: cst_error CONSTANT VARCHAR2(1) := 'E';
2906: CURSOR c_seq_no IS

Line 2908: FROM IGS_AD_APPL_LTR aal,

2904: cst_warn CONSTANT VARCHAR2(1) := 'W';
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

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