[Home] [Help]
229: FROM igs_ad_ps_appl_inst apai,
230: igs_ad_ps_appl psapl,
231: igs_ad_ou_stat aos,
232: igs_ad_appl aa,
233: igs_ad_appl_stat aps
234: 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
235: (( 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
236: (( Aa.adm_cal_type = cp_adm_cal_type AND cp_adm_cal_type IS NOT NULL) OR (cp_adm_cal_type IS NULL) ) AND
237: (( 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
238: (( Aa.admission_cat = cp_admission_cat AND cp_admission_cat IS NOT NULL) OR (cp_admission_cat IS NULL)) AND
239: (( Aa.s_admission_process_type = cp_s_adm_process_typ AND cp_s_adm_process_typ IS NOT NULL) OR (cp_s_adm_process_typ IS NULL) ) AND
240: Apai.adm_outcome_status = aos.adm_outcome_status AND
241: Aos.s_adm_outcome_status = 'PENDING' AND
242: NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN') AND
243: Psapl.req_for_reconsideration_ind = 'Y' AND
244: Apai.person_id = psapl.person_id AND
245: Apai.admission_appl_number = psapl.admission_appl_number AND
246: Apai.nominated_course_cd = psapl.nominated_course_cd AND
272: (( Aa.admission_cat = cp_admission_cat AND cp_admission_cat IS NOT NULL) OR (cp_admission_cat IS NULL)) AND
273: (( Aa.s_admission_process_type = cp_s_adm_process_typ AND cp_s_adm_process_typ IS NOT NULL) OR (cp_s_adm_process_typ IS NULL) ) AND
274: Apai.adm_outcome_status = aos.adm_outcome_status AND
275: Aos.s_adm_outcome_status = 'PENDING' AND
276: NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN') AND
277: Psapl.req_for_reconsideration_ind <> 'Y' AND
278: Apai.person_id = psapl.person_id AND
279: Apai.admission_appl_number = psapl.admission_appl_number AND
280: Apai.nominated_course_cd = psapl.nominated_course_cd AND
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
321: AND apai.admission_appl_number = cp_admission_appl_number
322: AND apai.nominated_course_cd = cp_nominated_course_cd
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;
419: Igs_ad_ps_appl_inst apai,
420: igs_ad_ps_appl psapl,
421: Igs_ad_ou_stat aos,
422: Igs_ad_appl aa,
423: Igs_ad_appl_stat aps
424: WHERE
425: Apai.person_id IN ';
426:
427: l_sql_stmt2 VARCHAR2(4000) := ' AND
432: Aa.admission_cat = NVL ( :5, aa.admission_cat) AND
433: Aa.s_admission_process_type = NVL ( :6 , aa.s_admission_process_type) AND
434: Apai.adm_outcome_status = aos.adm_outcome_status AND
435: Aos.s_adm_outcome_status = ''PENDING'' AND
436: NVL(apai.appl_inst_status,''RECEIVED'') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = ''WITHDRAWN'') AND
437: Psapl.req_for_reconsideration_ind = ''Y'' AND
438: Apai.person_id = psapl.person_id AND
439: Apai.admission_appl_number = psapl.admission_appl_number AND
440: Apai.nominated_course_cd = psapl.nominated_course_cd AND
1473: Aa.admission_cat = NVL ( :5 , aa.admission_cat) AND
1474: Aa.s_admission_process_type = NVL ( :6 , aa.s_admission_process_type) AND
1475: Apai.adm_outcome_status = aos.adm_outcome_status AND
1476: Aos.s_adm_outcome_status = ''PENDING'' AND
1477: NVL(apai.appl_inst_status,''RECEIVED'') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = ''WITHDRAWN'') AND
1478: Psapl.req_for_reconsideration_ind <> ''Y'' AND
1479: Apai.person_id = psapl.person_id AND
1480: Apai.admission_appl_number = psapl.admission_appl_number AND
1481: Apai.nominated_course_cd = psapl.nominated_course_cd AND