APPS.IGS_AU_GEN_004 dependencies on IGS_PS_UNT_INLV_HIST

Line 134: p_unit_int_course_level_cd IGS_PS_UNT_INLV_HIST_ALL.unit_int_course_level_cd%TYPE ,

130: END audp_get_udh_col;
131:
132: Function Audp_Get_Uiclh_Col(
133: p_column_name user_tab_columns.column_name%TYPE ,
134: p_unit_int_course_level_cd IGS_PS_UNT_INLV_HIST_ALL.unit_int_course_level_cd%TYPE ,
135: p_hist_end_dt IGS_PS_UNT_INLV_HIST_ALL.hist_end_dt%TYPE )
136: RETURN VARCHAR2 AS
137:
138: BEGIN -- audp_get_uiclh_col

Line 135: p_hist_end_dt IGS_PS_UNT_INLV_HIST_ALL.hist_end_dt%TYPE )

131:
132: Function Audp_Get_Uiclh_Col(
133: p_column_name user_tab_columns.column_name%TYPE ,
134: p_unit_int_course_level_cd IGS_PS_UNT_INLV_HIST_ALL.unit_int_course_level_cd%TYPE ,
135: p_hist_end_dt IGS_PS_UNT_INLV_HIST_ALL.hist_end_dt%TYPE )
136: RETURN VARCHAR2 AS
137:
138: BEGIN -- audp_get_uiclh_col
139: -- get the oldest column value (after a given date) for a given

Line 150: FROM IGS_PS_UNT_INLV_HIST uiclh

146: SELECT DECODE (p_column_name,
147: cst_description, uiclh.description,
148: cst_weftsu_factor, TO_CHAR(uiclh.weftsu_factor),
149: cst_closed_ind, uiclh.closed_ind)
150: FROM IGS_PS_UNT_INLV_HIST uiclh
151: WHERE uiclh.unit_int_course_level_cd = p_unit_int_course_level_cd AND
152: uiclh.hist_start_dt >= p_hist_end_dt AND
153: DECODE (p_column_name,
154: cst_description, uiclh.description,