234:
235:
236: FUNCTION audp_get_dh_col(
237: p_column_name user_tab_columns.column_name%TYPE ,
238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,
239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )
240: RETURN VARCHAR2 AS
241:
242: BEGIN -- audp_get_dh_col
235:
236: FUNCTION audp_get_dh_col(
237: p_column_name user_tab_columns.column_name%TYPE ,
238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,
239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )
240: RETURN VARCHAR2 AS
241:
242: BEGIN -- audp_get_dh_col
243: -- get the oldest column value (after a given date) for a given