eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_APPL

Line 222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,

218: lv_sql_stmt VARCHAR(32767) ;
219:
220:
221:
222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,

Line 223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,

219:
220:
221:
222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS

Line 224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,

220:
221:
222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*

Line 225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,

221:
222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*
229: FROM igs_ad_ps_appl_inst apai,

Line 226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,

222: CURSOR c_get_ad_ps_appl (cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*
229: FROM igs_ad_ps_appl_inst apai,
230: igs_ad_ps_appl psapl,

Line 227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS

223: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
224: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
225: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
226: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
227: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE) IS
228: SELECT distinct psapl.*
229: FROM igs_ad_ps_appl_inst apai,
230: igs_ad_ps_appl psapl,
231: igs_ad_ou_stat aos,

Line 232: igs_ad_appl aa,

228: SELECT distinct psapl.*
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

Line 233: igs_ad_appl_stat aps

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

Line 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

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

Line 257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,

253: AND apai.future_adm_cal_type IS NOT NULL AND apai.future_adm_ci_sequence_number IS NOT NULL)));
254:
255: l_get_ad_ps_appl_rec c_get_ad_ps_appl%ROWTYPE;
256:
257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,

Line 258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,

254:
255: l_get_ad_ps_appl_rec c_get_ad_ps_appl%ROWTYPE;
256:
257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS

Line 259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,

255: l_get_ad_ps_appl_rec c_get_ad_ps_appl%ROWTYPE;
256:
257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
263: SELECT apai.rowid, apai.*

Line 260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,

256:
257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
263: SELECT apai.rowid, apai.*
264: FROM Igs_ad_ps_appl_inst apai,

Line 261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,

257: CURSOR c_get_fut_appl_inst(cp_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE,
258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
263: SELECT apai.rowid, apai.*
264: FROM Igs_ad_ps_appl_inst apai,
265: Igs_ad_ps_appl psapl,

Line 262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS

258: cp_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE,
259: cp_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE,
260: cp_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE,
261: cp_admission_cat Igs_ad_appl.admission_cat%TYPE,
262: cp_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE)IS
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,

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 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

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

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 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');

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;

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 398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;

394: AND admission_appl_number = cp_admission_appl_number;
395:
396: l_adm_cat c_adm_cat%ROWTYPE;
397:
398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;
399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;

Line 399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;

395:
396: l_adm_cat c_adm_cat%ROWTYPE;
397:
398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;
399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;
403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;

Line 400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;

396: l_adm_cat c_adm_cat%ROWTYPE;
397:
398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;
399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;
403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;
404: l_processing_ind VARCHAR2(1);

Line 401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;

397:
398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;
399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;
403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;
404: l_processing_ind VARCHAR2(1);
405:

Line 402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;

398: l_acad_cal_type Igs_ad_appl.acad_cal_type%TYPE ;
399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;
403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;
404: l_processing_ind VARCHAR2(1);
405:
406: -- this indicator will keep a track whether the cancel reconsideration job failed for any of the application programs.

Line 403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;

399: l_acad_sequence_number Igs_ad_appl.acad_ci_sequence_number%TYPE ;
400: l_adm_cal_type Igs_ad_appl.adm_cal_type%TYPE ;
401: l_adm_sequence_number Igs_ad_appl.adm_ci_sequence_number%TYPE ;
402: l_admission_cat Igs_ad_appl.admission_cat%TYPE ;
403: l_s_adm_process_typ Igs_ad_appl.s_admission_process_type%TYPE;
404: l_processing_ind VARCHAR2(1);
405:
406: -- this indicator will keep a track whether the cancel reconsideration job failed for any of the application programs.
407: l_record_errored VARCHAR2(1) ;

Line 422: Igs_ad_appl aa,

418: FROM
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:

Line 423: Igs_ad_appl_stat aps

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

Line 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

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

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:

Line 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

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