[Home] [Help]
430:
431:
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col
431:
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col
439: -- get the oldest column value (after a given date) for the
432: FUNCTION Audp_Get_Scah_Col(
433: p_column_name IN user_tab_columns.column_name%TYPE ,
434: p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
436: p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
437: RETURN VARCHAR2 AS
438: BEGIN -- audp_get_scah_col
439: -- get the oldest column value (after a given date) for the
440: -- student course attempt history table