DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 157: lp_instructor_id IN igs_ps_usec_tch_resp.instructor_id%TYPE )

153: lp_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
154: lp_location_description IN igs_ad_location.description%TYPE,
155: lp_title IN igs_ps_unit_ver_all.title%TYPE,
156: lp_short_title IN igs_ps_unit_ver_all.short_title%TYPE,
157: lp_instructor_id IN igs_ps_usec_tch_resp.instructor_id%TYPE )
158: IS
159:
160: /*
161: || Created By : nmankodi

Line 311: igs_ps_usec_tch_resp utr,

307: uv.short_title,
308: utr.instructor_id
309: FROM igs_ps_unit_ofr_opt uoo,
310: igs_ps_unit_ver uv,
311: igs_ps_usec_tch_resp utr,
312: igs_ad_location loc
313: WHERE uoo.cal_type = cp_teach_cal_type
314: AND uoo.ci_sequence_number = cp_teach_ci_sequence_number
315: AND uoo.unit_cd = uv.unit_cd