DBA Data[Home] [Help]

APPS.IGS_EN_GEN_004 dependencies on USER_TAB_COLUMNS

Line 348: CURSOR c_sca_hist (cp_column_name user_tab_columns.column_name%TYPE,

344: RETURN VARCHAR2 AS
345: gv_other_detail VARCHAR2(255);
346: BEGIN
347: DECLARE
348: CURSOR c_sca_hist (cp_column_name user_tab_columns.column_name%TYPE,
349: cp_person_id IGS_AS_SC_ATTEMPT_H.person_id%TYPE,
350: cp_course_cd IGS_AS_SC_ATTEMPT_H.course_cd%TYPE,
351: cp_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE) IS
352: SELECT DECODE(cp_column_name, 'VERSION_NUMBER', TO_CHAR(scah.version_number),