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_GR_VAL_AWC dependencies on IGS_GR_AWD_CEREMONY

Line 172: FROM IGS_GR_AWD_CEREMONY awc

168: v_acusg_us_group_number IGS_GR_AWD_CRM_US_GP.us_group_number%TYPE;
169: v_message_name VARCHAR2(30);
170: CURSOR c_awc IS
171: SELECT 'X'
172: FROM IGS_GR_AWD_CEREMONY awc
173: WHERE awc.grd_cal_type = p_grd_cal_type AND
174: awc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
175: awc.ceremony_number = p_ceremony_number AND
176: awc.order_in_ceremony = p_order_in_ceremony AND

Line 277: FROM IGS_GR_AWD_CEREMONY awc1,

273: DECLARE
274: v_awc_acusg_exists VARCHAR2(1);
275: CURSOR c_awc_acusg IS
276: SELECT 'x'
277: FROM IGS_GR_AWD_CEREMONY awc1,
278: IGS_GR_AWD_CEREMONY awc2,
279: IGS_GR_AWD_CRM_US_GP acusg1,
280: IGS_GR_AWD_CRM_US_GP acusg2
281: WHERE acusg1.grd_cal_type = p_grd_cal_type AND

Line 278: IGS_GR_AWD_CEREMONY awc2,

274: v_awc_acusg_exists VARCHAR2(1);
275: CURSOR c_awc_acusg IS
276: SELECT 'x'
277: FROM IGS_GR_AWD_CEREMONY awc1,
278: IGS_GR_AWD_CEREMONY awc2,
279: IGS_GR_AWD_CRM_US_GP acusg1,
280: IGS_GR_AWD_CRM_US_GP acusg2
281: WHERE acusg1.grd_cal_type = p_grd_cal_type AND
282: acusg1.grd_ci_sequence_number = p_grd_ci_sequence_number AND