APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AD_BUILDING

Line 28: igs_ad_building b,

24: uoo_id,
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

Line 80: igs_ad_building b,

76: DECODE(a.sunday, 'Y', 'Sun', NULL),'-')||'
'||
77: TO_CHAR(a.start_time, 'hh:miam')||'-'|| TO_CHAR(a.end_time, 'hh:miam')||'
'||
78: LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) instructor_name
79: FROM igs_ps_usec_occurs a,
80: igs_ad_building b,
81: hz_parties f
82: WHERE
83: a.building_code = b.building_id(+) AND
84: a.instructor_id = f.party_id(+) AND

Line 173: igs_ad_building b,

169: NVL(b.description,'-')||' '||
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

Line 241: igs_ad_building b,

237: || DECODE(a.sunday, 'Y', 'Sun', NULL) ||' '
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

Line 346: igs_ad_building b,

342: TO_CHAR(a.start_time, 'hh:miam')||'-'||
343: TO_CHAR(a.end_time, 'hh:miam')||'
'||
344: LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) occurence
345: FROM igs_ps_usec_occurs a,
346: igs_ad_building b,
347: hz_parties f
348: WHERE
349: a.building_code = b.building_id(+) AND
350: a.instructor_id = f.party_id(+) AND

Line 3274: FROM igs_ad_building_all

3270: -- Internal function to get the building code for the given building identifier
3271: FUNCTION get_building_code(p_n_building_id IN NUMBER) RETURN VARCHAR2 IS
3272: CURSOR c_building_code (cp_n_building_id IN NUMBER) IS
3273: SELECT building_cd
3274: FROM igs_ad_building_all
3275: WHERE building_id = cp_n_building_id;
3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;
3277: BEGIN
3278: OPEN c_building_code (p_n_building_id );

Line 3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;

3272: CURSOR c_building_code (cp_n_building_id IN NUMBER) IS
3273: SELECT building_cd
3274: FROM igs_ad_building_all
3275: WHERE building_id = cp_n_building_id;
3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;
3277: BEGIN
3278: OPEN c_building_code (p_n_building_id );
3279: FETCH c_building_code INTO l_c_building_cd;
3280: CLOSE c_building_code;