APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_APPL_ALL

Line 267: Igs_ad_appl_all Aa

263: SELECT apai.rowid, apai.*
264: FROM Igs_ad_ps_appl_inst apai,
265: Igs_ad_ps_appl psapl,
266: Igs_ad_ou_stat aos,
267: Igs_ad_appl_all Aa
268: WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
269: (( Aa.acad_ci_sequence_number = cp_acad_sequence_number AND cp_acad_sequence_number IS NOT NULL)OR (cp_acad_sequence_number IS NULL) ) AND
270: (( Aa.adm_cal_type = cp_adm_cal_type AND cp_adm_cal_type IS NOT NULL) OR (cp_adm_cal_type IS NULL) ) AND
271: (( Aa.adm_ci_sequence_number = cp_adm_sequence_number AND cp_adm_sequence_number IS NOT NULL) OR (cp_adm_sequence_number IS NULL) ) AND

Line 308: CURSOR c_get_application_id (cp_person_id igs_ad_appl_all.person_id%TYPE,

304: AND lookup_code = cp_s_admission_process_type;
305:
306: l_get_adm_process_type igs_ad_prcs_cat_v.meaning%TYPE;
307:
308: CURSOR c_get_application_id (cp_person_id igs_ad_appl_all.person_id%TYPE,
309: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
310: SELECT application_id
311: FROM igs_ad_appl_all
312: WHERE person_id = cp_person_id

Line 309: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

305:
306: l_get_adm_process_type igs_ad_prcs_cat_v.meaning%TYPE;
307:
308: CURSOR c_get_application_id (cp_person_id igs_ad_appl_all.person_id%TYPE,
309: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
310: SELECT application_id
311: FROM igs_ad_appl_all
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;

Line 311: FROM igs_ad_appl_all

307:
308: CURSOR c_get_application_id (cp_person_id igs_ad_appl_all.person_id%TYPE,
309: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
310: SELECT application_id
311: FROM igs_ad_appl_all
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

Line 327: l_get_application_id igs_ad_appl_all.application_id%TYPE;

323: AND NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN');
324:
325: l_get_inst_dtls_rec c_get_inst_dtls%ROWTYPE;
326:
327: l_get_application_id igs_ad_appl_all.application_id%TYPE;
328:
329: CURSOR c_get_aplinsthist_dtls(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
330: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE,
331: cp_nominated_course_cd igs_ad_ps_aplinsthst_all.nominated_course_cd%TYPE,

Line 392: FROM igs_ad_appl_all

388:
389: CURSOR c_adm_cat(cp_person_id igs_ad_ps_aplinsthst_all.person_id%TYPE,
390: cp_admission_appl_number igs_ad_ps_aplinsthst_all.admission_appl_number%TYPE) IS
391: SELECT admission_cat,s_admission_process_type
392: FROM igs_ad_appl_all
393: WHERE person_id = cp_person_id
394: AND admission_appl_number = cp_admission_appl_number;
395:
396: l_adm_cat c_adm_cat%ROWTYPE;

Line 586: Igs_ad_appl_all Aa

582: apai.decline_ofr_reason
583: FROM Igs_ad_ps_appl_inst apai,
584: Igs_ad_ps_appl psapl,
585: Igs_ad_ou_stat aos,
586: Igs_ad_appl_all Aa
587: WHERE Apai.person_id IN ';
588:
589: l_sql_stmt4 VARCHAR2(4000) ;
590: