DBA Data[Home] [Help]

APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_AD_LOCATION

Line 154: lp_location_description IN igs_ad_location.description%TYPE,

150: lp_grading_period_end_dt IN DATE,
151: lp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
152: lp_unit_class IN igs_ps_unit_ofr_opt.unit_class%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

Line 312: igs_ad_location loc

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
316: AND uoo.version_number = uv.version_number