APPS.IGS_AD_AC_COMP dependencies on IGS_AD_DOC_STAT

Line 128: FROM igs_ad_doc_stat

124:
125: -- Get the details of
126: CURSOR cur_adm_doc_status IS
127: SELECT adm_doc_status
128: FROM igs_ad_doc_stat
129: WHERE s_adm_doc_status = 'SATISFIED'
130: AND closed_ind = 'N'
131: AND system_default_ind= 'Y';
132:

Line 399: igs_ad_doc_stat ads

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
403: AND apai.sequence_number = p_sequence_number

Line 419: igs_ad_doc_stat ads

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'
423: AND apai.adm_outcome_status = aos.adm_outcome_status

Line 442: igs_ad_doc_stat ads

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
446: AND aa.acad_ci_sequence_number = p_acad_ci_sequence_number

Line 610: igs_ad_doc_stat ads

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''
614: AND apai.adm_outcome_status = aos.adm_outcome_status

Line 643: igs_ad_doc_stat ads

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''
647: AND apai.adm_outcome_status = aos.adm_outcome_status