APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AD_BUILDING_ALL

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

5779:
5780: -- Carry out derivations and validate them
5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd

Line 5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS

5780: -- Carry out derivations and validate them
5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;

Line 5786: FROM igs_ad_building_all

5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;
5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,

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

5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;
5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
5791: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
5792: SELECT room_id
5793: FROM igs_ad_room_all
5794: WHERE room_cd = cp_room_cd