APPS.IGS_AD_AC_COMP dependencies on IGS_AD_OU_STAT

Line 398: igs_ad_ou_stat aos,

394: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE
395: ) IS
396: SELECT person_id, admission_appl_number, course_cd, sequence_number
397: FROM igs_ad_ps_appl_inst apai,
398: igs_ad_ou_stat aos,
399: igs_ad_doc_stat ads
400: WHERE apai.person_id = p_person_id
401: AND apai.admission_appl_number = p_admission_appl_number
402: AND apai.course_cd = p_course_cd

Line 418: igs_ad_ou_stat aos,

414: p_person_id igs_ad_ps_appl_inst.person_id%TYPE
415: ) IS
416: SELECT apai.person_id, apai.admission_appl_number, apai.course_cd, apai.sequence_number
417: FROM igs_ad_ps_appl_inst apai,
418: igs_ad_ou_stat aos,
419: igs_ad_doc_stat ads
420: WHERE apai.person_id = p_person_id
421: AND aos.s_adm_outcome_status IN ('PENDING','COND-OFFER')
422: AND aos.closed_ind = 'N'

Line 441: igs_ad_ou_stat aos,

437: ) IS
438: SELECT apai.person_id, apai.admission_appl_number, apai. course_cd, apai.sequence_number
439: FROM igs_ad_ps_appl_inst apai,
440: igs_ad_appl aa,
441: igs_ad_ou_stat aos,
442: igs_ad_doc_stat ads
443: WHERE apai.person_id = aa.person_id
444: AND apai.admission_appl_number = aa.admission_appl_number
445: AND aa.acad_cal_type = p_acad_cal_type

Line 609: igs_ad_ou_stat aos,

605:
606: OPEN c_dyn_pig_check FOR
607: 'SELECT apai.person_id, apai.admission_appl_number, apai.course_cd, apai.sequence_number
608: FROM igs_ad_ps_appl_inst apai,
609: igs_ad_ou_stat aos,
610: igs_ad_doc_stat ads
611: WHERE apai.person_id IN ( '||lv_sql_stmt||')
612: AND aos.s_adm_outcome_status IN (''PENDING'',''COND-OFFER'')
613: AND aos.closed_ind = ''N''

Line 642: igs_ad_ou_stat aos,

638:
639: OPEN c_dyn_pig_check FOR
640: 'SELECT apai.person_id, apai.admission_appl_number, apai.course_cd, apai.sequence_number
641: FROM igs_ad_ps_appl_inst apai,
642: igs_ad_ou_stat aos,
643: igs_ad_doc_stat ads
644: WHERE apai.person_id IN ( '||lv_sql_stmt||')
645: AND aos.s_adm_outcome_status IN (''PENDING'',''COND-OFFER'')
646: AND aos.closed_ind = ''N''