APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_PS_UNIT_VER

Line 233: FROM igs_ps_unit_ver

229: ORDER BY course_cd, version_number;
230:
231: CURSOR cur_unit_rev_cd IS
232: SELECT unit_cd, version_number, rev_account_cd
233: FROM igs_ps_unit_ver
234: WHERE rev_account_cd IS NOT NULL
235: ORDER BY unit_cd, version_number;
236:
237: CURSOR cur_uoo_rev_cd IS

Line 288: unit_cd igs_ps_unit_ver.unit_cd%TYPE,

284:
285:
286: --For Unit.
287: TYPE unit_rec_type IS RECORD (
288: unit_cd igs_ps_unit_ver.unit_cd%TYPE,
289: version_number igs_ps_unit_ver.version_number%TYPE,
290: rev_account_cd igs_ps_unit_ver.rev_account_cd%TYPE);
291:
292: TYPE unit_tbl_type IS TABLE OF unit_rec_type INDEX BY BINARY_INTEGER;

Line 289: version_number igs_ps_unit_ver.version_number%TYPE,

285:
286: --For Unit.
287: TYPE unit_rec_type IS RECORD (
288: unit_cd igs_ps_unit_ver.unit_cd%TYPE,
289: version_number igs_ps_unit_ver.version_number%TYPE,
290: rev_account_cd igs_ps_unit_ver.rev_account_cd%TYPE);
291:
292: TYPE unit_tbl_type IS TABLE OF unit_rec_type INDEX BY BINARY_INTEGER;
293: unit_tbl unit_tbl_type;

Line 290: rev_account_cd igs_ps_unit_ver.rev_account_cd%TYPE);

286: --For Unit.
287: TYPE unit_rec_type IS RECORD (
288: unit_cd igs_ps_unit_ver.unit_cd%TYPE,
289: version_number igs_ps_unit_ver.version_number%TYPE,
290: rev_account_cd igs_ps_unit_ver.rev_account_cd%TYPE);
291:
292: TYPE unit_tbl_type IS TABLE OF unit_rec_type INDEX BY BINARY_INTEGER;
293: unit_tbl unit_tbl_type;
294: