APPS.IGS_GR_VAL_GC dependencies on IGS_GR_VENUE

Line 372: FROM IGS_GR_VENUE ve,

368: v_ve_lot_found VARCHAR2(1);
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

Line 415: v_venue_cd IGS_GR_VENUE.venue_cd%TYPE;

411: RETURN boolean AS
412: BEGIN -- assp_val_ve_closed
413: -- Validate the venue closed indicator
414: DECLARE
415: v_venue_cd IGS_GR_VENUE.venue_cd%TYPE;
416: v_ve_closed_ind IGS_GR_VENUE.closed_ind%TYPE;
417: v_ret_val BOOLEAN DEFAULT TRUE;
418: CURSOR c_ve IS
419: SELECT closed_ind

Line 416: v_ve_closed_ind IGS_GR_VENUE.closed_ind%TYPE;

412: BEGIN -- assp_val_ve_closed
413: -- Validate the venue closed indicator
414: DECLARE
415: v_venue_cd IGS_GR_VENUE.venue_cd%TYPE;
416: v_ve_closed_ind IGS_GR_VENUE.closed_ind%TYPE;
417: v_ret_val BOOLEAN DEFAULT TRUE;
418: CURSOR c_ve IS
419: SELECT closed_ind
420: FROM IGS_GR_VENUE

Line 420: FROM IGS_GR_VENUE

416: v_ve_closed_ind IGS_GR_VENUE.closed_ind%TYPE;
417: v_ret_val BOOLEAN DEFAULT TRUE;
418: CURSOR c_ve IS
419: SELECT closed_ind
420: FROM IGS_GR_VENUE
421: WHERE venue_cd = p_venue_cd;
422: BEGIN
423: p_message_name := NULL;
424: OPEN c_ve;