DBA Data[Home] [Help]

APPS.IGF_AW_ROLLOVER dependencies on IGS_PS_VER_ALL

Line 348: CURSOR c_get_program_ver ( cp_program_code igs_ps_ver_all.course_cd%TYPE

344: FROM igf_aw_fund_prg_all prg
345: WHERE fund_id = cp_ref_fund_id;
346:
347: -- Cursor to fetch all the existing versions for the program type
348: CURSOR c_get_program_ver ( cp_program_code igs_ps_ver_all.course_cd%TYPE
349: ) IS
350: SELECT version_number
351: FROM igs_ps_ver_all
352: WHERE course_cd = cp_program_code

Line 351: FROM igs_ps_ver_all

347: -- Cursor to fetch all the existing versions for the program type
348: CURSOR c_get_program_ver ( cp_program_code igs_ps_ver_all.course_cd%TYPE
349: ) IS
350: SELECT version_number
351: FROM igs_ps_ver_all
352: WHERE course_cd = cp_program_code
353: ORDER BY version_number asc;
354:
355: