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_003 dependencies on IGS_OR_INST_HIST_ALL

Line 278: p_institution_cd IN IGS_OR_INST_HIST_ALL.institution_cd%TYPE ,

274:
275:
276: FUNCTION Audp_Get_Ih_Col(
277: p_column_name IN user_tab_columns.column_name%TYPE ,
278: p_institution_cd IN IGS_OR_INST_HIST_ALL.institution_cd%TYPE ,
279: p_hist_end_dt IN IGS_OR_INST_HIST_ALL.hist_end_dt%TYPE )
280: RETURN VARCHAR2 AS
281: /*
282: || Created By : [email protected]

Line 279: p_hist_end_dt IN IGS_OR_INST_HIST_ALL.hist_end_dt%TYPE )

275:
276: FUNCTION Audp_Get_Ih_Col(
277: p_column_name IN user_tab_columns.column_name%TYPE ,
278: p_institution_cd IN IGS_OR_INST_HIST_ALL.institution_cd%TYPE ,
279: p_hist_end_dt IN IGS_OR_INST_HIST_ALL.hist_end_dt%TYPE )
280: RETURN VARCHAR2 AS
281: /*
282: || Created By : [email protected]
283: || Created On : 28-AUG-2000

Line 332: FROM IGS_OR_INST_HIST_ALL ih

328: cst_govt_institution_cd, ih.GOVT_INSTITUTION_CD,
329: cst_institution_type, ih.INSTITUTION_TYPE,
330: cst_description, ih.description,
331: cst_inst_control_type, ih.INST_CONTROL_TYPE )
332: FROM IGS_OR_INST_HIST_ALL ih
333: WHERE ih.institution_cd = p_institution_cd AND
334: ih.hist_start_dt >= p_hist_end_dt AND
335: DECODE (
336: p_column_name,