APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_TRANSACTIONS

Line 178: FROM igs_uc_transactions tran

174: CURSOR cur_latest_trans( p_app_no igs_uc_app_choices.app_no%TYPE,
175: p_choice_no igs_uc_app_choices.choice_no%TYPE,
176: p_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
177: SELECT *
178: FROM igs_uc_transactions tran
179: WHERE tran.app_no = p_app_no
180: AND tran.choice_no = p_choice_no
181: AND tran.ucas_cycle = p_ucas_cycle
182: AND tran.transaction_type IN ( 'LA','LD','RA','RD','RX' )

Line 191: FROM igs_uc_transactions tran

187: CURSOR cur_unprocess_trans_exist( p_app_no igs_uc_app_choices.app_no%TYPE,
188: p_choice_no igs_uc_app_choices.choice_no%TYPE,
189: p_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
190: SELECT 'X'
191: FROM igs_uc_transactions tran
192: WHERE tran.app_no = p_app_no
193: AND tran.choice_no = p_choice_no
194: AND tran.ucas_cycle = p_ucas_cycle
195: AND tran.transaction_type IN ( 'LA','LD','RA','RD','RX' )

Line 332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;

328: -- Define the Local Variables
329: l_conc_request_id NUMBER(15);
330: l_app_inst_sys_adm_ou_status igs_ad_ou_stat.s_adm_outcome_status%TYPE;
331: l_oss_ou_status_of_app_choice igs_ad_ou_stat.adm_outcome_status%TYPE;
332: l_latest_trans_decision igs_uc_transactions.decision%TYPE;
333:
334: l_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
335: l_deffered_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;
336: l_current_batch_id igs_ad_batc_def_det_all.batch_id%TYPE ;