APPS.IGS_GR_VAL_GC dependencies on IGS_AD_LOCATION

Line 373: IGS_AD_LOCATION loc,

369: cst_grd_ctr CONSTANT VARCHAR2(10) := 'GRD_CTR';
370: CURSOR c_ve IS
371: SELECT 'x'
372: FROM IGS_GR_VENUE ve,
373: IGS_AD_LOCATION loc,
374: IGS_AD_LOCATION_TYPE lot
375: WHERE ve.venue_cd = p_venue_cd AND
376: ve.exam_location_cd = loc.location_cd AND
377: loc.location_type = lot.location_type AND

Line 374: IGS_AD_LOCATION_TYPE lot

370: CURSOR c_ve IS
371: SELECT 'x'
372: FROM IGS_GR_VENUE ve,
373: IGS_AD_LOCATION loc,
374: IGS_AD_LOCATION_TYPE lot
375: WHERE ve.venue_cd = p_venue_cd AND
376: ve.exam_location_cd = loc.location_cd AND
377: loc.location_type = lot.location_type AND
378: lot.s_location_type = cst_grd_ctr;