APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_MAP_OFF_RESP

Line 2057: FROM igs_uc_map_off_resp

2053: CURSOR c_curr_off_resp_status (cp_system_code igs_uc_app_choices.system_code%TYPE,
2054: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE,
2055: cp_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE) IS
2056: SELECT 'X'
2057: FROM igs_uc_map_off_resp
2058: WHERE decision_code= cp_decision_code
2059: AND system_code = cp_system_code
2060: AND closed_ind = 'N'
2061: AND reply_code = 'F'

Line 2076: FROM igs_uc_map_off_resp

2072:
2073: CURSOR c_new_off_resp_status(cp_system_code igs_uc_app_choices.system_code%TYPE,
2074: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE) IS
2075: SELECT adm_offer_resp_status
2076: FROM igs_uc_map_off_resp
2077: WHERE system_code = cp_system_code
2078: AND decision_code= cp_decision_code
2079: AND closed_ind = 'N'
2080: AND reply_code = 'F' ;

Line 2082: l_new_off_resp_status igs_uc_map_off_resp.adm_offer_resp_status%TYPE;

2078: AND decision_code= cp_decision_code
2079: AND closed_ind = 'N'
2080: AND reply_code = 'F' ;
2081:
2082: l_new_off_resp_status igs_uc_map_off_resp.adm_offer_resp_status%TYPE;
2083:
2084: BEGIN
2085:
2086: OPEN c_sys_cd(p_alt_appl_id);