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_002 dependencies on IGS_PS_DSCP_HIST

Line 238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,

234:
235:
236: FUNCTION audp_get_dh_col(
237: p_column_name user_tab_columns.column_name%TYPE ,
238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,
239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )
240: RETURN VARCHAR2 AS
241:
242: BEGIN -- audp_get_dh_col

Line 239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )

235:
236: FUNCTION audp_get_dh_col(
237: p_column_name user_tab_columns.column_name%TYPE ,
238: p_dscplne_grp_cd igs_ps_dscp_hist_all.discipline_group_cd%TYPE ,
239: p_hist_end_dt igs_ps_dscp_hist_all.hist_end_dt%TYPE )
240: RETURN VARCHAR2 AS
241:
242: BEGIN -- audp_get_dh_col
243: -- get the oldest column value (after a given date) for a given

Line 260: FROM igs_ps_dscp_hist dh

256: cst_funding_index_2, TO_CHAR(dh.funding_index_2),
257: cst_funding_index_3, TO_CHAR(dh.funding_index_3),
258: cst_gvt_dscplne_grp_cd, dh.govt_discipline_group_cd,
259: cst_closed_ind, dh.closed_ind)
260: FROM igs_ps_dscp_hist dh
261: WHERE dh.discipline_group_cd = p_dscplne_grp_cd AND
262: dh.hist_start_dt >= p_hist_end_dt AND
263: decode (p_column_name,
264: cst_description, dh.description,