APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_AD_BUILDING_ALL

Line 6164: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,

6160: END validate_parameters;
6161:
6162: PROCEDURE validate_derivations ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6163:
6164: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
6165: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
6166: SELECT building_id
6167: FROM igs_ad_building_all
6168: WHERE

Line 6165: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS

6161:
6162: PROCEDURE validate_derivations ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6163:
6164: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
6165: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
6166: SELECT building_id
6167: FROM igs_ad_building_all
6168: WHERE
6169: building_cd = cp_building_cd AND

Line 6167: FROM igs_ad_building_all

6163:
6164: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
6165: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
6166: SELECT building_id
6167: FROM igs_ad_building_all
6168: WHERE
6169: building_cd = cp_building_cd AND
6170: location_cd = cp_location_cd;
6171:

Line 6172: CURSOR c_build_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE) IS

6168: WHERE
6169: building_cd = cp_building_cd AND
6170: location_cd = cp_location_cd;
6171:
6172: CURSOR c_build_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE) IS
6173: SELECT building_id
6174: FROM igs_ad_building_all
6175: WHERE building_cd = cp_building_cd;
6176:

Line 6174: FROM igs_ad_building_all

6170: location_cd = cp_location_cd;
6171:
6172: CURSOR c_build_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE) IS
6173: SELECT building_id
6174: FROM igs_ad_building_all
6175: WHERE building_cd = cp_building_cd;
6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS

Line 6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,

6173: SELECT building_id
6174: FROM igs_ad_building_all
6175: WHERE building_cd = cp_building_cd;
6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
6179: SELECT room_id
6180: FROM igs_ad_room_all
6181: WHERE