APPS.IGS_GE_GEN_001 dependencies on IGS_AD_LOCATION

Line 669: FROM IGS_AD_LOCATION loc

665: -- cursor for selection of the location name
666: CURSOR c_loc_name (
667: cp_location_cd VARCHAR2)IS
668: SELECT loc.description loc_description
669: FROM IGS_AD_LOCATION loc
670: WHERE loc.location_cd = cp_location_cd;
671: -- cursor for selection of the location address when
672: -- only the loc_unit_cd is supplied
673: --skpandey Bug#3687099, Changed definition of cursor c_loc to optimize query