APPS.IGS_FI_ACCT_STP_CNV dependencies on IGS_PS_UNIT_OFR_OPT

Line 239: FROM igs_ps_unit_ofr_opt

235: ORDER BY unit_cd, version_number;
236:
237: CURSOR cur_uoo_rev_cd IS
238: SELECT uoo_id, rev_account_cd
239: FROM igs_ps_unit_ofr_opt
240: WHERE rev_account_cd IS NOT NULL
241: ORDER BY unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class;
242:
243: CURSOR cur_loc_rev_cd IS

Line 298: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

294:
295:
296: --For Unit Section.
297: TYPE usec_rec_type IS RECORD (
298: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
299: rev_account_cd igs_ps_unit_ofr_opt.rev_account_cd%TYPE);
300:
301: TYPE usec_tbl_type IS TABLE OF usec_rec_type INDEX BY BINARY_INTEGER;
302: usec_tbl usec_tbl_type;

Line 299: rev_account_cd igs_ps_unit_ofr_opt.rev_account_cd%TYPE);

295:
296: --For Unit Section.
297: TYPE usec_rec_type IS RECORD (
298: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
299: rev_account_cd igs_ps_unit_ofr_opt.rev_account_cd%TYPE);
300:
301: TYPE usec_tbl_type IS TABLE OF usec_rec_type INDEX BY BINARY_INTEGER;
302: usec_tbl usec_tbl_type;
303: