APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_MAP_OUT_STAT

Line 96: CURSOR ucas_decision_cd_cur( p_system_code igs_uc_map_out_stat.system_code%TYPE,

92: FROM igs_uc_app_clr_rnd
93: WHERE app_no = cp_app_no;
94:
95: -- To Fetch the Decision Mapping to Admission Outcome Status for a UCAS System
96: CURSOR ucas_decision_cd_cur( p_system_code igs_uc_map_out_stat.system_code%TYPE,
97: p_adm_outcome_status igs_uc_map_out_stat.adm_outcome_status%TYPE) IS
98: SELECT decision_code
99: FROM igs_uc_map_out_stat
100: WHERE system_code = p_system_code AND

Line 97: p_adm_outcome_status igs_uc_map_out_stat.adm_outcome_status%TYPE) IS

93: WHERE app_no = cp_app_no;
94:
95: -- To Fetch the Decision Mapping to Admission Outcome Status for a UCAS System
96: CURSOR ucas_decision_cd_cur( p_system_code igs_uc_map_out_stat.system_code%TYPE,
97: p_adm_outcome_status igs_uc_map_out_stat.adm_outcome_status%TYPE) IS
98: SELECT decision_code
99: FROM igs_uc_map_out_stat
100: WHERE system_code = p_system_code AND
101: adm_outcome_status = p_adm_outcome_status AND

Line 99: FROM igs_uc_map_out_stat

95: -- To Fetch the Decision Mapping to Admission Outcome Status for a UCAS System
96: CURSOR ucas_decision_cd_cur( p_system_code igs_uc_map_out_stat.system_code%TYPE,
97: p_adm_outcome_status igs_uc_map_out_stat.adm_outcome_status%TYPE) IS
98: SELECT decision_code
99: FROM igs_uc_map_out_stat
100: WHERE system_code = p_system_code AND
101: adm_outcome_status = p_adm_outcome_status AND
102: closed_ind = 'N';
103: