DBA Data[Home] [Help]

APPS.IGS_UC_GEN_001 dependencies on IGS_UC_UCAS_CONTROL

Line 9: p_system_code IN igs_uc_ucas_control.system_code%TYPE,

5: PROCEDURE cvname_references(p_type IN VARCHAR2,
6: p_appno IN NUMBER,
7: p_surname IN VARCHAR2,
8: p_birthdate IN DATE,
9: p_system_code IN igs_uc_ucas_control.system_code%TYPE,
10: l_result OUT NOCOPY igs_uc_gen_001.cur_step_def) IS
11:
12: /******************************************************************
13: Created By : pmarada

Line 177: FROM igs_uc_ucas_control

173: ***************************************************************** */
174:
175: CURSOR c_uc_control IS
176: SELECT time_of_year, extra_start_date, last_le_date, transaction_toy_code
177: FROM igs_uc_ucas_control
178: WHERE system_code = p_system_code
179: AND ucas_cycle = p_ucas_cycle;
180:
181: l_uc_control c_uc_control%ROWTYPE;