APPS.IGS_AS_GEN_002 dependencies on IGS_AD_LOCATION_REL

Line 49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam

45: BEGIN -- assp_get_dflt_exloc
46: -- This routine returns the default examination IGS_AD_LOCATION
47: -- for a nominated campus.
48: -- The default IGS_AD_LOCATION is signified by the dflt_ind being set in the
49: -- IGS_AD_LOCATION_REL table between the specified campus and an exam
50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd

Line 54: FROM igs_ad_location_rel lr,

50: -- IGS_AD_LOCATION.
51: DECLARE
52: CURSOR c_lr IS
53: SELECT lr.sub_location_cd
54: FROM igs_ad_location_rel lr,
55: igs_ad_location loc,
56: igs_ad_location_type lt
57: WHERE lr.location_cd = p_location_cd
58: AND NVL (lr.dflt_ind, 'N') = 'Y'

Line 63: v_sub_location_cd igs_ad_location_rel.location_cd%TYPE DEFAULT NULL;

59: AND NVL (loc.closed_ind, 'N') = 'N'
60: AND lt.s_location_type = 'EXAM_CTR'
61: AND loc.location_cd = lr.location_cd
62: AND loc.location_type = lt.location_type;
63: v_sub_location_cd igs_ad_location_rel.location_cd%TYPE DEFAULT NULL;
64: BEGIN
65: -- Search for the default exam IGS_AD_LOCATION
66: OPEN c_lr;
67: FETCH c_lr INTO v_sub_location_cd;