DBA Data[Home] [Help]

APPS.IGF_AW_ROLLOVER dependencies on IGS_PS_UNIT_VER_ALL

Line 284: CURSOR c_get_unit_ver ( cp_unit_code igs_ps_unit_ver_all.unit_cd%TYPE

280: FROM igf_aw_fund_unit_all unt
281: WHERE fund_id = cp_ref_fund_id;
282:
283: -- Cursor to fetch all the existing versions for the UNIT
284: CURSOR c_get_unit_ver ( cp_unit_code igs_ps_unit_ver_all.unit_cd%TYPE
285: ) IS
286: SELECT version_number
287: FROM igs_ps_unit_ver_all
288: WHERE unit_cd = cp_unit_code

Line 287: FROM igs_ps_unit_ver_all

283: -- Cursor to fetch all the existing versions for the UNIT
284: CURSOR c_get_unit_ver ( cp_unit_code igs_ps_unit_ver_all.unit_cd%TYPE
285: ) IS
286: SELECT version_number
287: FROM igs_ps_unit_ver_all
288: WHERE unit_cd = cp_unit_code
289: ORDER BY version_number asc;
290:
291: l_rowid VARCHAR2(25);