237:
238: --
239: --Get the Segment Values for the Location Entity
240: --
241: CURSOR cur_ad_loc_accts (cp_location_cd igs_ad_loc_accts.location_cd%TYPE)
242: IS
243: SELECT segment_num,segment_value
244: FROM igs_ad_loc_accts
245: WHERE location_cd = cp_location_cd;
240: --
241: CURSOR cur_ad_loc_accts (cp_location_cd igs_ad_loc_accts.location_cd%TYPE)
242: IS
243: SELECT segment_num,segment_value
244: FROM igs_ad_loc_accts
245: WHERE location_cd = cp_location_cd;
246:
247: --
248: --Get the Segment Values for the Sub Account Entity