APPS.IGS_AU_GEN_003 dependencies on IGS_GR_GRADUAND_HIST

Line 190: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,

186: END;
187: END audp_get_gach_col;
188:
189: FUNCTION Audp_Get_Grh_Col(
190: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,
191: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,
192: p_column_name user_tab_columns.column_name%TYPE ,
193: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )
194: RETURN VARCHAR2 AS

Line 191: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,

187: END audp_get_gach_col;
188:
189: FUNCTION Audp_Get_Grh_Col(
190: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,
191: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,
192: p_column_name user_tab_columns.column_name%TYPE ,
193: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )
194: RETURN VARCHAR2 AS
195: BEGIN -- audp_get_grh_col

Line 193: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )

189: FUNCTION Audp_Get_Grh_Col(
190: p_person_id IGS_GR_GRADUAND_HIST_ALL.person_id%TYPE ,
191: p_create_dt IGS_GR_GRADUAND_HIST_ALL.create_dt%TYPE ,
192: p_column_name user_tab_columns.column_name%TYPE ,
193: p_hist_dt IGS_GR_GRADUAND_HIST_ALL.hist_start_dt%TYPE )
194: RETURN VARCHAR2 AS
195: BEGIN -- audp_get_grh_col
196: -- Get the oldest column value(after a given date) for a
197: -- given p_person_id and p_create_dt.

Line 236: FROM IGS_GR_GRADUAND_HIST grh

232: cst_sur_for_course_cd, grh.sur_for_course_cd,
233: cst_sur_for_crs_version_number, TO_CHAR(grh.sur_for_crs_version_number),
234: cst_sur_for_award_cd, grh.sur_for_award_cd,
235: cst_comments, grh.comments)
236: FROM IGS_GR_GRADUAND_HIST grh
237: WHERE grh.person_id = p_person_id AND
238: grh.create_dt = p_create_dt AND
239: grh.hist_start_dt >= p_hist_dt AND
240: DECODE (p_column_name,