241: ORDER BY unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class;
242:
243: CURSOR cur_loc_rev_cd IS
244: SELECT location_cd, rev_account_cd
245: FROM igs_ad_location
246: WHERE rev_account_cd IS NOT NULL
247: ORDER BY location_cd;
248:
249: CURSOR cur_org_rev_cd IS
303:
304:
305: --For Location.
306: TYPE loc_rec_type IS RECORD (
307: location_cd igs_ad_location.location_cd%TYPE,
308: rev_account_cd igs_ad_location.rev_account_cd%TYPE);
309:
310: TYPE loc_tbl_type IS TABLE OF loc_rec_type INDEX BY BINARY_INTEGER;
311: loc_tbl loc_tbl_type;
304:
305: --For Location.
306: TYPE loc_rec_type IS RECORD (
307: location_cd igs_ad_location.location_cd%TYPE,
308: rev_account_cd igs_ad_location.rev_account_cd%TYPE);
309:
310: TYPE loc_tbl_type IS TABLE OF loc_rec_type INDEX BY BINARY_INTEGER;
311: loc_tbl loc_tbl_type;
312: