APPS.IGF_AP_OSS_INTEGR dependencies on IGS_AD_OU_STAT

Line 402: IGS_AD_OU_STAT oustat,

398: FROM IGS_AD_APPL aav,
399: IGS_AD_PS_APPL_INST acai,
400: IGS_PS_VER crv,
401: IGS_AD_APPL_STAT apstat,
402: IGS_AD_OU_STAT oustat,
403: IGS_AD_OFR_RESP_STAT rpstat
404: WHERE aav.person_id = acai.person_id (+)
405: AND aav.admission_appl_number = acai.admission_appl_number(+)
406: AND aav.person_id = p_person_id

Line 509: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;

505: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
506: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
507: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
508: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
509: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
510: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
511: lv_multiple VARCHAR2(10) ;
512: BEGIN
513:

Line 558: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;

554: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
555: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
556: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
557: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
558: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
559: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
560: lv_multiple VARCHAR2(10) ;
561: BEGIN
562: