DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_UC_TRANSACTIONS

Line 1089: FROM IGS_UC_TRANSACTIONS tran

1085: CURSOR cur_latest_trans( p_app_no igs_uc_app_choices.app_no%TYPE,
1086: p_choice_no igs_uc_app_choices.choice_no%TYPE,
1087: p_ucas_cycle igs_uc_app_choices.ucas_cycle%TYPE) IS
1088: SELECT transaction_type,program_code,entry_month,entry_year,entry_point
1089: FROM IGS_UC_TRANSACTIONS tran
1090: WHERE tran.app_no = p_app_no
1091: AND tran.choice_no = p_choice_no
1092: AND tran.ucas_cycle = p_ucas_cycle
1093: ORDER BY tran.uc_tran_id DESC;