APPS.IGS_AU_GEN_002 dependencies on IGS_PS_FLD_STDY_HIST

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

Line 360: -- specified field_of_study from IGS_PS_FLD_STDY_HIST

356: RETURN VARCHAR2 AS
357:
358: BEGIN -- audp_get_fosh_col
359: -- get the oldest column value (after a given date) for a
360: -- specified field_of_study from IGS_PS_FLD_STDY_HIST
361: DECLARE
362: CURSOR c_fosh IS
363: SELECT
364: decode (p_column_name,

Line 368: FROM igs_ps_fld_stdy_hist fosh

364: decode (p_column_name,
365: 'DESCRIPTION', fosh.description,
366: 'GOVT_FIELD_OF_STUDY', fosh.govt_field_of_study,
367: 'CLOSED_IND', fosh.closed_ind)
368: FROM igs_ps_fld_stdy_hist fosh
369: WHERE fosh.field_of_study = p_field_of_study AND
370: fosh.hist_start_dt >= p_hist_end_dt AND
371: decode (p_column_name,
372: 'DESCRIPTION', fosh.description,