APPS.IGS_OR_LOC_REGION_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 111: FROM igs_ps_unit_ofr_opt_all uooa,

107: || (reverse chronological order - newest change first)
108: */
109: CURSOR cur_prcd IS
110: SELECT 1
111: FROM igs_ps_unit_ofr_opt_all uooa,
112: igs_ps_usec_occurs_all uoa
113: WHERE uoa.preferred_region_code = x_region_cd
114: AND uoa.uoo_id = uooa.uoo_id
115: AND uooa.location_cd = x_location_cd;