DBA Data[Home] [Help]

APPS.IGS_AU_GEN_001 dependencies on IGS_PS_FLD_STD_HIST_ALL

Line 423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,

419: END;
420: END audp_get_acaiuh_col;
421:
422: Function Audp_Get_Cfosh_Col(
423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
426: p_column_name user_tab_columns.column_name%TYPE ,
427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )

Line 424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,

420: END audp_get_acaiuh_col;
421:
422: Function Audp_Get_Cfosh_Col(
423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
426: p_column_name user_tab_columns.column_name%TYPE ,
427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )
428: RETURN VARCHAR2 AS

Line 425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,

421:
422: Function Audp_Get_Cfosh_Col(
423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
426: p_column_name user_tab_columns.column_name%TYPE ,
427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )
428: RETURN VARCHAR2 AS
429:

Line 427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )

423: p_course_cd IGS_PS_FLD_STD_HIST_ALL.course_cd%TYPE ,
424: p_version_number IGS_PS_FLD_STD_HIST_ALL.version_number%TYPE ,
425: p_field_of_study IGS_PS_FLD_STD_HIST_ALL.field_of_study%TYPE ,
426: p_column_name user_tab_columns.column_name%TYPE ,
427: p_hist_date IGS_PS_FLD_STD_HIST_ALL.hist_start_dt%TYPE )
428: RETURN VARCHAR2 AS
429:
430: BEGIN -- audp_get_cfosh_col
431: -- get the column_value (after a given date) for a given