APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_OU_STAT

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 1078: CURSOR c_obs_ou_stat ( cp_out_stat igs_ad_ou_stat.adm_outcome_status%TYPE) IS

1074: FROM igs_uc_defaults def
1075: WHERE def.system_code = NVL(cp_system_code, def.system_code);
1076: c_defaults_rec c_defaults%ROWTYPE ;
1077:
1078: CURSOR c_obs_ou_stat ( cp_out_stat igs_ad_ou_stat.adm_outcome_status%TYPE) IS
1079: SELECT s_Adm_outcome_status
1080: FROM igs_Ad_ou_stat
1081: WHERE adm_outcome_status = cp_out_stat ;
1082: l_s_obsol_ou_stat igs_ad_ou_stat.s_adm_outcome_status%TYPE ;

Line 1080: FROM igs_Ad_ou_stat

1076: c_defaults_rec c_defaults%ROWTYPE ;
1077:
1078: CURSOR c_obs_ou_stat ( cp_out_stat igs_ad_ou_stat.adm_outcome_status%TYPE) IS
1079: SELECT s_Adm_outcome_status
1080: FROM igs_Ad_ou_stat
1081: WHERE adm_outcome_status = cp_out_stat ;
1082: l_s_obsol_ou_stat igs_ad_ou_stat.s_adm_outcome_status%TYPE ;
1083:
1084: -- Cursor to fetch the latest Transaction

Line 1082: l_s_obsol_ou_stat igs_ad_ou_stat.s_adm_outcome_status%TYPE ;

1078: CURSOR c_obs_ou_stat ( cp_out_stat igs_ad_ou_stat.adm_outcome_status%TYPE) IS
1079: SELECT s_Adm_outcome_status
1080: FROM igs_Ad_ou_stat
1081: WHERE adm_outcome_status = cp_out_stat ;
1082: l_s_obsol_ou_stat igs_ad_ou_stat.s_adm_outcome_status%TYPE ;
1083:
1084: -- Cursor to fetch the latest Transaction
1085: CURSOR cur_latest_trans( p_app_no igs_uc_app_choices.app_no%TYPE,
1086: p_choice_no igs_uc_app_choices.choice_no%TYPE,