eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AU_GEN_001 dependencies on IGS_PS_FLD_STD_HIST

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

Line 441: FROM IGS_PS_FLD_STD_HIST cfosh

437: CURSOR c_cfosh IS
438: SELECT DECODE (p_column_name,
439: cst_percentage, TO_CHAR(cfosh.percentage),
440: cst_major_field_ind, cfosh.major_field_ind)
441: FROM IGS_PS_FLD_STD_HIST cfosh
442: WHERE cfosh.course_cd = p_course_cd AND
443: cfosh.version_number = p_version_number AND
444: cfosh.field_of_study = p_field_of_study AND
445: cfosh.hist_start_dt >= p_hist_date AND