APPS.IGS_SS_ENR_DETAILS dependencies on HZ_PARTIES

Line 81: hz_parties f

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
85: a.uoo_id = p_uoo_id ORDER BY

Line 176: hz_parties f

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
179: a.room_code = c.room_id(+) AND
180: a.instructor_id = f.party_id(+) AND

Line 254: hz_parties hz,

250: IS
251: SELECT
252: person_Last_name ||', '||Person_first_name||' '|| person_middle_name instructor_name
253: FROM
254: hz_parties hz,
255: igs_ps_uso_instrctrs usoi
256: WHERE
257: hz.party_id = usoi.instructor_id AND
258: usoi.unit_section_occurrence_id = p_unit_section_occurence_id;

Line 347: hz_parties f

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
351: a.uoo_id = p_uoo_id ORDER BY

Line 1780: hz_parties hz,

1776: CURSOR c_usec_instructor_names
1777: IS
1778: SELECT hz.person_last_name || ', '||hz.person_first_name || ' '||hz.person_middle_name instructor_name
1779: FROM
1780: hz_parties hz,
1781: igs_ps_uso_instrctrs a
1782: WHERE a.instructor_id(+) = hz.party_id
1783: AND a.unit_section_occurrence_id = p_uoo_id
1784: ORDER BY 1 ;