APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AD_LOCATION_ALL

Line 5937: CURSOR c_loc_cd(cp_location_cd igs_ad_location_all.location_cd%TYPE) IS

5933: END assign_defaults;
5934:
5935: -- Validate Database Constraints
5936: PROCEDURE validate_db_cons ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,p_insert_update VARCHAR2 ) AS
5937: CURSOR c_loc_cd(cp_location_cd igs_ad_location_all.location_cd%TYPE) IS
5938: SELECT 'X'
5939: FROM igs_ad_location_all
5940: WHERE location_cd = cp_location_cd
5941: AND closed_ind = 'N';

Line 5939: FROM igs_ad_location_all

5935: -- Validate Database Constraints
5936: PROCEDURE validate_db_cons ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,p_insert_update VARCHAR2 ) AS
5937: CURSOR c_loc_cd(cp_location_cd igs_ad_location_all.location_cd%TYPE) IS
5938: SELECT 'X'
5939: FROM igs_ad_location_all
5940: WHERE location_cd = cp_location_cd
5941: AND closed_ind = 'N';
5942:
5943: c_loc_cd_rec c_loc_cd%ROWTYPE;