DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_AD_LOCATION_TYPE_ALL

Line 658: igs_ad_location_type_all b

654:
655: CURSOR c_location_type ( cp_location_cd igs_ad_location_all.location_cd%TYPE ) IS
656: SELECT 'x'
657: FROM igs_ad_location_all a,
658: igs_ad_location_type_all b
659: WHERE a.location_type = b.location_type
660: AND b.s_location_type = 'CAMPUS'
661: AND a.location_cd = cp_location_cd;
662: rec_location_type c_location_type%ROWTYPE;