APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AD_ROOM

Line 29: igs_ad_room c,

25: NVL(d.description,'-')||'
'||NVL(b.description,'-')||'
'||NVL(c.description,'-') location_description,
26: NVL(b.location_cd,'-')||'
'||NVL(b.building_cd,'-')||'
'||NVL(c.room_cd,'-') location_cd
27: FROM igs_ps_usec_occurs a,
28: igs_ad_building b,
29: igs_ad_room c,
30: igs_ad_location d
31: WHERE
32: a.building_code = b.building_id(+) AND
33: a.room_code = c.room_id(+) AND

Line 174: igs_ad_room c,

170: NVL(c.description,'')||'
'||
171: LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) location
172: FROM igs_ps_usec_occurs a,
173: igs_ad_building b,
174: igs_ad_room c,
175: igs_ad_location d,
176: hz_parties f
177: WHERE
178: a.building_code = b.building_id(+) AND

Line 242: igs_ad_room c

238: || TO_CHAR(a.start_time,'hh:miam')||'-'||TO_CHAR(a.end_time, 'hh:miam')
239: ||'
'||NVL(b.location_cd,' ')||'
'||NVL(b.building_cd,' ') ||' '||NVL(c.room_cd,' ') location
240: FROM igs_ps_usec_occurs a,
241: igs_ad_building b,
242: igs_ad_room c
243: WHERE
244: a.building_code = b.building_id(+) AND
245: a.room_code = c.room_id(+) AND
246: a.uoo_id = p_uoo_id

Line 3288: FROM igs_ad_room_all

3284: -- Internal function to get the room code for the given room identifier
3285: FUNCTION get_room_code(p_n_room_id IN NUMBER) RETURN VARCHAR2 IS
3286: CURSOR c_room_code (cp_n_room_id IN NUMBER) IS
3287: SELECT room_cd
3288: FROM igs_ad_room_all
3289: WHERE room_id = cp_n_room_id;
3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;
3291: BEGIN
3292: OPEN c_room_code (p_n_room_id );

Line 3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;

3286: CURSOR c_room_code (cp_n_room_id IN NUMBER) IS
3287: SELECT room_cd
3288: FROM igs_ad_room_all
3289: WHERE room_id = cp_n_room_id;
3290: l_c_room_cd igs_ad_room_all.room_cd%TYPE;
3291: BEGIN
3292: OPEN c_room_code (p_n_room_id );
3293: FETCH c_room_code INTO l_c_room_cd;
3294: CLOSE c_room_code;