APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_OU_STAT

Line 231: igs_ad_ou_stat aos,

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

Line 266: Igs_ad_ou_stat aos,

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

Line 421: Igs_ad_ou_stat aos,

417: psapl.course_rank_set,psapl.course_rank_schedule, psapl.req_for_adv_standing_ind
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 ';

Line 585: Igs_ad_ou_stat aos,

581: apai.ais_reason,
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) ;