APPS.IGS_AU_GEN_002 dependencies on IGS_PS_VER_HIST_ALL

Line 76: p_course_cd igs_ps_ver_hist_all.course_cd%TYPE ,

72: vvutukur 19_oct-2002 Enh#2608227.removed references to std_ft_completion_time,std_pt_completion_time
73: ayedubat 25-MAY-2001 modified the procedure to add new columns
74: (reverse chronological order - newest change first)
75: ***************************************************************/
76: p_course_cd igs_ps_ver_hist_all.course_cd%TYPE ,
77: p_version_number igs_ps_ver_hist_all.version_number%TYPE ,
78: p_column_name user_tab_columns.column_name%TYPE ,
79: p_hist_date igs_ps_ver_hist_all.hist_start_dt%TYPE )
80: RETURN VARCHAR2 AS

Line 77: p_version_number igs_ps_ver_hist_all.version_number%TYPE ,

73: ayedubat 25-MAY-2001 modified the procedure to add new columns
74: (reverse chronological order - newest change first)
75: ***************************************************************/
76: p_course_cd igs_ps_ver_hist_all.course_cd%TYPE ,
77: p_version_number igs_ps_ver_hist_all.version_number%TYPE ,
78: p_column_name user_tab_columns.column_name%TYPE ,
79: p_hist_date igs_ps_ver_hist_all.hist_start_dt%TYPE )
80: RETURN VARCHAR2 AS
81:

Line 79: p_hist_date igs_ps_ver_hist_all.hist_start_dt%TYPE )

75: ***************************************************************/
76: p_course_cd igs_ps_ver_hist_all.course_cd%TYPE ,
77: p_version_number igs_ps_ver_hist_all.version_number%TYPE ,
78: p_column_name user_tab_columns.column_name%TYPE ,
79: p_hist_date igs_ps_ver_hist_all.hist_start_dt%TYPE )
80: RETURN VARCHAR2 AS
81:
82: BEGIN -- audp_get_cvh_col
83: -- Get the oldest column value (after a given date) for a given