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_AD_PS_APLINSTHST

Line 151: -- IGS_AD_PS_APLINSTHST table

147: BEGIN -- audp_get_acaih_col
148: -- get the oldest column value (after a given date) for a
149: -- specified column and person_id, admission_appl_number,
150: -- nominated_course_cd and sequence_number for
151: -- IGS_AD_PS_APLINSTHST table
152: DECLARE
153: cst_hist_offer_round_number CONSTANT
154: VARCHAR2(23) := 'HIST_OFFER_ROUND_NUMBER';
155: cst_adm_cal_type CONSTANT VARCHAR2(12) := 'ADM_CAL_TYPE';

Line 262: FROM IGS_AD_PS_APLINSTHST acaih

258: cst_enrolment_cat, acaih.ENROLMENT_CAT,
259: cst_funding_source, acaih.FUNDING_SOURCE,
260: cst_applicant_acptnce_cndtn, acaih.applicant_acptnce_cndtn,
261: cst_cndtnl_offer_cndtn, acaih.cndtnl_offer_cndtn)
262: FROM IGS_AD_PS_APLINSTHST acaih
263: WHERE acaih.person_id = p_person_id AND
264: acaih.admission_appl_number = p_admission_appl_number AND
265: acaih.nominated_course_cd = p_nominated_course_cd AND
266: acaih.sequence_number = p_sequence_number AND