372:
373:
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col
373:
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col
381: -- get the oldest column value (after a given date) for a
374: FUNCTION Audp_Get_Ouh_Col(
375: p_column_name IN user_tab_columns.column_name%TYPE ,
376: p_org_unit_cd IN IGS_OR_UNIT_HIST_ALL.institution_cd%TYPE ,
377: p_ou_start_dt IN IGS_OR_UNIT_HIST_ALL.ou_start_dt%TYPE ,
378: p_hist_end_dt IN IGS_OR_UNIT_HIST_ALL.hist_end_dt%TYPE )
379: RETURN VARCHAR2 AS
380: BEGIN -- audp_get_ouh_col
381: -- get the oldest column value (after a given date) for a
382: -- specified column and institution_cd for IGS_OR_UNIT_HIST table