APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AD_BUILDING_ALL

Line 3274: FROM igs_ad_building_all

3270: -- Internal function to get the building code for the given building identifier
3271: FUNCTION get_building_code(p_n_building_id IN NUMBER) RETURN VARCHAR2 IS
3272: CURSOR c_building_code (cp_n_building_id IN NUMBER) IS
3273: SELECT building_cd
3274: FROM igs_ad_building_all
3275: WHERE building_id = cp_n_building_id;
3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;
3277: BEGIN
3278: OPEN c_building_code (p_n_building_id );

Line 3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;

3272: CURSOR c_building_code (cp_n_building_id IN NUMBER) IS
3273: SELECT building_cd
3274: FROM igs_ad_building_all
3275: WHERE building_id = cp_n_building_id;
3276: l_c_building_cd igs_ad_building_all.building_cd%TYPE;
3277: BEGIN
3278: OPEN c_building_code (p_n_building_id );
3279: FETCH c_building_code INTO l_c_building_cd;
3280: CLOSE c_building_code;