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_AD_UNIT_SETS_PKG dependencies on IGS_PS_COO_AD_UNIT_S

Line 427: FROM igs_ps_coo_ad_unit_s psus

423: AND psusv.attendance_mode = NVL(p_attendance_mode, psusv.attendance_mode)
424: AND psusv.attendance_type = NVL(p_attendance_type, psusv.attendance_type)
425: AND NOT EXISTS
426: (SELECT 1
427: FROM igs_ps_coo_ad_unit_s psus
428: WHERE psus.course_cd = psusv.course_cd
429: AND psus.crv_version_number = psusv.crv_version_number
430: AND psus.cal_type = psusv.cal_type
431: AND psus.location_cd = psusv.location_cd

Line 451: FROM igs_ps_coo_ad_unit_s psus,

447: )
448: AND psusv.expiry_dt IS NULL
449: UNION
450: SELECT '1'
451: FROM igs_ps_coo_ad_unit_s psus,
452: igs_en_unit_set us
453: WHERE psus.unit_set_cd = p_unit_set_cd -- extra condition, when compared to unit set lov query on IGSAD097.pld, IGSAD046.pld
454: AND psus.us_version_number = p_version_number -- extra condition, when compared to unit set lov query on IGSAD097.pld, IGSAD046.pld
455: AND us.unit_set_cd = psus.unit_set_cd