APPS.IGS_AD_GEN_014 dependencies on IGS_AD_SS_APPL_TYP

Line 137: CURSOR c_appl_type(p_admission_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS

133: SELECT NVL(MAX(admission_appl_number),0) + 1
134: FROM IGS_AD_APPL /*Replaced as part of Bug 3150054*/
135: WHERE person_id = p_person_id;
136:
137: CURSOR c_appl_type(p_admission_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
138: SELECT a.admission_application_type
139: FROM igs_ad_ss_appl_typ a,
140: igs_ad_prcs_cat_v b
141: WHERE a.closed_ind = 'N'

Line 139: FROM igs_ad_ss_appl_typ a,

135: WHERE person_id = p_person_id;
136:
137: CURSOR c_appl_type(p_admission_application_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
138: SELECT a.admission_application_type
139: FROM igs_ad_ss_appl_typ a,
140: igs_ad_prcs_cat_v b
141: WHERE a.closed_ind = 'N'
142: AND a.admission_cat = b.admission_cat
143: AND a.s_admission_process_type = b.s_admission_process_type

Line 147: l_appl_type igs_ad_ss_appl_typ.admission_application_type%TYPE;

143: AND a.s_admission_process_type = b.s_admission_process_type
144: AND b.closed_ind ='N'
145: AND a.admission_application_type = p_admission_application_type;
146:
147: l_appl_type igs_ad_ss_appl_typ.admission_application_type%TYPE;
148: lv_rowid VARCHAR2(25);
149: l_org_id NUMBER(15);
150: v_effective_dt DATE;
151: