APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_PS_APPL_INST_ALL

Line 869: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e

865: cp_unit_set_cd igs_ad_ps_appl_inst.unit_set_cd%TYPE ,
866: cp_us_version_number igs_ad_ps_appl_inst.us_version_number%TYPE ) IS
867: SELECT 'X'
868: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,
869: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e
870: WHERE a.app_no = b.app_no AND
871: a.oss_person_id = c.person_id AND
872: TO_CHAR(a.app_no) = c.alt_appl_id AND
873: b.choice_no = c.choice_number AND

Line 908: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e

904: e.decision_date , e.decision_reason_id , e.decision_make_id ,e.adm_outcome_status ,
905: e.nominated_course_cd , c.adm_cal_type , c.adm_ci_sequence_number,
906: c.acad_cal_type , c.acad_ci_sequence_number ,c.admission_cat ,c.s_admission_process_type
907: FROM igs_uc_applicants a , igs_uc_app_choices b , igs_ad_appl_all c,
908: igs_ad_ps_appl_all d , igs_ad_ps_appl_inst_all e
909: WHERE a.app_no = b.app_no AND
910: a.oss_person_id = c.person_id AND
911: TO_CHAR(a.app_no) = c.alt_appl_id AND
912: b.choice_no = c.choice_number AND

Line 945: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou

941: CURSOR c_obsol_appl_cnt(cp_app_no igs_uc_applicants.app_no%TYPE ,
942: cp_choice_number igs_ad_appl_all.choice_number%TYPE) IS
943: SELECT COUNT(*)
944: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,
945: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou
946: WHERE a.app_no = cp_app_no AND
947: a.oss_person_id = c.person_id AND
948: TO_CHAR(a.app_no) = c.alt_appl_id AND
949: c.choice_number = cp_choice_number AND

Line 968: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou

964: e.decision_date , e.decision_reason_id , e.decision_make_id ,e.adm_outcome_status ,
965: e.nominated_course_cd , c.adm_cal_type , c.adm_ci_sequence_number,
966: c.acad_cal_type , c.acad_ci_sequence_number ,c.admission_cat ,c.s_admission_process_type
967: FROM igs_uc_applicants a , igs_ad_appl_all c, igs_ad_ps_appl_all d ,
968: igs_ad_ps_appl_inst_all e , igs_ad_ou_stat ou
969: WHERE a.app_no = cp_app_no AND
970: a.oss_person_id = c.person_id AND
971: TO_CHAR(a.app_no) = c.alt_appl_id AND
972: c.choice_number = cp_choice_number AND

Line 986: FROM igs_ad_ps_appl_inst_all a

982: -- Get the application instance details for incrementing preference number
983: CURSOR c_upd_appl_inst ( cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
984: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE ) IS
985: SELECT a.ROWID , a.*
986: FROM igs_ad_ps_appl_inst_all a
987: WHERE a.person_id = cp_person_id AND
988: a.admission_appl_number = cp_admission_appl_number
989: ORDER BY a.preference_number DESC ;
990:

Line 1106: IGS_AD_PS_APPL_INST_ALL aplinst

1102: FROM IGS_UC_APP_CHOICES uac,
1103: IGS_UC_APPLICANTS ua,
1104: IGS_AD_APPL_ALL apl,
1105: IGS_AD_PS_APPL_ALL aplps,
1106: IGS_AD_PS_APPL_INST_ALL aplinst
1107: WHERE uac.app_no = p_app_no
1108: AND uac.choice_no = p_choice_no
1109: AND uac.ucas_cycle= p_ucas_cycle
1110: AND ua.app_no = uac.app_no

Line 1137: igs_ad_ps_appl_inst_all aplinst,

1133: FROM
1134: igs_uc_app_choices uac,
1135: igs_uc_sys_calndrs ucal,
1136: igs_ad_appl_all apl,
1137: igs_ad_ps_appl_inst_all aplinst,
1138: igs_en_unit_set us,
1139: igs_en_unit_set_cat usc,
1140: igs_ps_us_prenr_cfg cnfg,
1141: igs_uc_map_out_stat mos,

Line 2306: FROM igs_ad_ps_appl_inst_all

2302: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
2303: SELECT admission_appl_number,
2304: nominated_course_cd,
2305: sequence_number
2306: FROM igs_ad_ps_appl_inst_all
2307: WHERE person_id = p_per_id;
2308:
2309: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
2310: SELECT COUNT(*)