[Home] [Help]
566: WHERE dai.cal_type = p_prg_cal_type AND
567: dai.ci_sequence_number = p_prg_sequence_number AND
568: dt_alias =
569: (SELECT sprgcc.effective_end_dt_alias
570: FROM IGS_PR_S_PRG_CONF sprgcc
571: WHERE sprgcc.s_control_num = 1)
572: ORDER BY 1 DESC; -- for latest if multiple dates exist
573: CURSOR c_ci IS
574: SELECT ci.end_dt