DBA Data[Home] [Help]

APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_AD_LOCATION

Line 245: FROM igs_ad_location

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

Line 307: location_cd igs_ad_location.location_cd%TYPE,

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;

Line 308: rev_account_cd igs_ad_location.rev_account_cd%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: