APPS.IGS_AD_VAL_AAL dependencies on IGS_AD_PRCS_CAT_LTR

Line 26: FROM IGS_AD_PRCS_CAT_LTR apcl

22: WHERE slet.s_letter_reference_type = 'ADM' AND
23: slet.correspondence_type = p_correspondence_type;
24: CURSOR c_apcl IS
25: SELECT 'X'
26: FROM IGS_AD_PRCS_CAT_LTR apcl
27: WHERE apcl.admission_cat = p_admission_cat AND
28: apcl.s_admission_process_type = p_s_admission_process_type;
29: CURSOR c_apcl_2 IS
30: SELECT 'X'

Line 31: FROM IGS_AD_PRCS_CAT_LTR apcl

27: WHERE apcl.admission_cat = p_admission_cat AND
28: apcl.s_admission_process_type = p_s_admission_process_type;
29: CURSOR c_apcl_2 IS
30: SELECT 'X'
31: FROM IGS_AD_PRCS_CAT_LTR apcl
32: WHERE apcl.admission_cat = p_admission_cat AND
33: apcl.s_admission_process_type = p_s_admission_process_type AND
34: apcl.correspondence_type = p_correspondence_type;
35: CURSOR c_apcs (