APPS.IGS_OR_VAL_LOC dependencies on IGS_GR_VENUE

Line 74: -- related IGS_GR_VENUE records are not closed.

70: RETURN BOOLEAN AS
71: gv_other_detail VARCHAR2(255);
72: BEGIN -- assp_val_loc_ve_open
73: -- Validate that an examination location can not be closed if any
74: -- related IGS_GR_VENUE records are not closed.
75: DECLARE
76: v_s_location_type IGS_AD_LOCATION.location_type%TYPE;
77: CURSOR c_ve IS
78: SELECT 'x'

Line 79: FROM IGS_GR_VENUE

75: DECLARE
76: v_s_location_type IGS_AD_LOCATION.location_type%TYPE;
77: CURSOR c_ve IS
78: SELECT 'x'
79: FROM IGS_GR_VENUE
80: WHERE exam_location_cd = p_location_cd AND
81: closed_ind = 'N';
82: v_ve_exists VARCHAR2(1);
83: BEGIN

Line 128: FROM IGS_GR_VENUE

124: cst_exam_ctr CONSTANT VARCHAR2(10) := 'EXAM_CTR';
125: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
126: CURSOR c_ve IS
127: SELECT 'x'
128: FROM IGS_GR_VENUE
129: WHERE exam_location_cd = p_location_cd;
130: v_ve_exists VARCHAR2(1);
131: BEGIN
132: -- Set the default message number