APPS.IGS_AU_GEN_002 dependencies on IGS_PS_VER_HIST

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

Line 173: FROM igs_ps_ver_hist cvh

169: cst_state_financial_aid, state_financial_aid,
170: cst_primary_program_rank, TO_CHAR(primary_program_rank),
171: l_c_max_wlst_per_stud, TO_CHAR(max_wlst_per_stud),
172: l_c_annual_instruction_time, TO_CHAR(annual_instruction_time))
173: FROM igs_ps_ver_hist cvh
174: WHERE cvh.course_cd = p_course_cd AND
175: cvh.version_number = p_version_number AND
176: cvh.hist_start_dt >= p_hist_date AND
177: decode (p_column_name,