DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_AD_LOCATION_ALL

Line 655: CURSOR c_location_type ( cp_location_cd igs_ad_location_all.location_cd%TYPE ) IS

651: l_n_call_number igs_ps_unit_ofr_opt_all.call_number%TYPE;
652: -- Removed l_n_unit_contact_id as a part of bug # 3121311
653: l_c_message VARCHAR2(30);
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

Line 657: FROM igs_ad_location_all a,

653: l_c_message VARCHAR2(30);
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;