APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_MAP_OUT_STAT

Line 2044: FROM igs_uc_map_out_stat

2040:
2041: CURSOR c_decision_cd(cp_system_code igs_uc_app_choices.system_code%TYPE,
2042: cp_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE) IS
2043: SELECT decision_code
2044: FROM igs_uc_map_out_stat
2045: WHERE system_code = cp_system_code
2046: AND adm_outcome_status = cp_outcome_status
2047: AND closed_ind = 'N';
2048:

Line 2049: l_decision_code igs_uc_map_out_stat.decision_code%TYPE;

2045: WHERE system_code = cp_system_code
2046: AND adm_outcome_status = cp_outcome_status
2047: AND closed_ind = 'N';
2048:
2049: l_decision_code igs_uc_map_out_stat.decision_code%TYPE;
2050:
2051: -- Cursor to find out if the reply code of Firm Acceptance is mapped to the decision code returned from the cursor (c_decision_cd) with the old outcome status
2052:
2053: CURSOR c_curr_off_resp_status (cp_system_code igs_uc_app_choices.system_code%TYPE,

Line 2054: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE,

2050:
2051: -- Cursor to find out if the reply code of Firm Acceptance is mapped to the decision code returned from the cursor (c_decision_cd) with the old outcome status
2052:
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

Line 2068: l_off_resp_dec_cd igs_uc_map_out_stat.decision_code%TYPE;

2064: l_curr_off_resp_status VARCHAR2(1);
2065:
2066: --Cursor to select the decision code associated with the new outcome status
2067:
2068: l_off_resp_dec_cd igs_uc_map_out_stat.decision_code%TYPE;
2069:
2070: -- Cursor to get the admission offer response mapped out to the reply code of Firm Acceptance and decision code returned from the cursor (c_decision_cd) with the new
2071: -- outcome status
2072:

Line 2074: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE) IS

2070: -- Cursor to get the admission offer response mapped out to the reply code of Firm Acceptance and decision code returned from the cursor (c_decision_cd) with the new
2071: -- outcome status
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