DBA Data[Home] [Help]

APPS.IGS_AU_GEN_002 dependencies on IGS_PS_FLD_STDY_HIST_ALL

Line 354: p_field_of_study igs_ps_fld_stdy_hist_all.field_of_study%TYPE ,

350: END audp_get_fcflh_col;
351:
352: FUNCTION audp_get_fosh_col(
353: p_column_name user_tab_columns.column_name%TYPE ,
354: p_field_of_study igs_ps_fld_stdy_hist_all.field_of_study%TYPE ,
355: p_hist_end_dt igs_ps_fld_stdy_hist_all.hist_end_dt%TYPE )
356: RETURN VARCHAR2 AS
357:
358: BEGIN -- audp_get_fosh_col

Line 355: p_hist_end_dt igs_ps_fld_stdy_hist_all.hist_end_dt%TYPE )

351:
352: FUNCTION audp_get_fosh_col(
353: p_column_name user_tab_columns.column_name%TYPE ,
354: p_field_of_study igs_ps_fld_stdy_hist_all.field_of_study%TYPE ,
355: p_hist_end_dt igs_ps_fld_stdy_hist_all.hist_end_dt%TYPE )
356: RETURN VARCHAR2 AS
357:
358: BEGIN -- audp_get_fosh_col
359: -- get the oldest column value (after a given date) for a