APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_PS_VER

Line 227: FROM igs_ps_ver

223: ORDER BY order_sequence;
224:
225: CURSOR cur_prg_rev_cd IS
226: SELECT course_cd, version_number, rev_account_cd
227: FROM igs_ps_ver
228: WHERE rev_account_cd IS NOT NULL
229: ORDER BY course_cd, version_number;
230:
231: CURSOR cur_unit_rev_cd IS

Line 278: course_cd igs_ps_ver.course_cd%TYPE,

274: l_v_entity_code igs_fi_hier_acct_tbl.entity_type_code%TYPE;
275:
276: --For Program.
277: TYPE prg_rec_type IS RECORD (
278: course_cd igs_ps_ver.course_cd%TYPE,
279: version_number igs_ps_ver.version_number%TYPE,
280: rev_account_cd igs_ps_ver.rev_account_cd%TYPE);
281:
282: TYPE prg_tbl_type IS TABLE OF prg_rec_type INDEX BY BINARY_INTEGER;

Line 279: version_number igs_ps_ver.version_number%TYPE,

275:
276: --For Program.
277: TYPE prg_rec_type IS RECORD (
278: course_cd igs_ps_ver.course_cd%TYPE,
279: version_number igs_ps_ver.version_number%TYPE,
280: rev_account_cd igs_ps_ver.rev_account_cd%TYPE);
281:
282: TYPE prg_tbl_type IS TABLE OF prg_rec_type INDEX BY BINARY_INTEGER;
283: prg_tbl prg_tbl_type;

Line 280: rev_account_cd igs_ps_ver.rev_account_cd%TYPE);

276: --For Program.
277: TYPE prg_rec_type IS RECORD (
278: course_cd igs_ps_ver.course_cd%TYPE,
279: version_number igs_ps_ver.version_number%TYPE,
280: rev_account_cd igs_ps_ver.rev_account_cd%TYPE);
281:
282: TYPE prg_tbl_type IS TABLE OF prg_rec_type INDEX BY BINARY_INTEGER;
283: prg_tbl prg_tbl_type;
284: