APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_MAP_OUT_STAT

Line 202: CURSOR cur_ou_mapping ( p_decision IGS_UC_MAP_OUT_STAT.DECISION_CODE%TYPE,

198:
199: -- Cursor to find the OSS User Outcome Status mapped to the defaulted Decision
200: -- of the current Application Instance
201: --smaddali modified cursor to add check for system_code ,for bug 2643048 UCFD102 build
202: CURSOR cur_ou_mapping ( p_decision IGS_UC_MAP_OUT_STAT.DECISION_CODE%TYPE,
203: p_system_code igs_uc_map_out_stat.system_code%TYPE) IS
204: SELECT mos.adm_outcome_status
205: FROM igs_uc_map_out_stat mos
206: WHERE mos.system_code = p_system_code

Line 203: p_system_code igs_uc_map_out_stat.system_code%TYPE) IS

199: -- Cursor to find the OSS User Outcome Status mapped to the defaulted Decision
200: -- of the current Application Instance
201: --smaddali modified cursor to add check for system_code ,for bug 2643048 UCFD102 build
202: CURSOR cur_ou_mapping ( p_decision IGS_UC_MAP_OUT_STAT.DECISION_CODE%TYPE,
203: p_system_code igs_uc_map_out_stat.system_code%TYPE) IS
204: SELECT mos.adm_outcome_status
205: FROM igs_uc_map_out_stat mos
206: WHERE mos.system_code = p_system_code
207: AND mos.decision_code = p_decision

Line 205: FROM igs_uc_map_out_stat mos

201: --smaddali modified cursor to add check for system_code ,for bug 2643048 UCFD102 build
202: CURSOR cur_ou_mapping ( p_decision IGS_UC_MAP_OUT_STAT.DECISION_CODE%TYPE,
203: p_system_code igs_uc_map_out_stat.system_code%TYPE) IS
204: SELECT mos.adm_outcome_status
205: FROM igs_uc_map_out_stat mos
206: WHERE mos.system_code = p_system_code
207: AND mos.decision_code = p_decision
208: AND mos.default_ind = 'Y'
209: AND mos.closed_ind <> 'Y' ;