DBA Data[Home] [Help]

APPS.IGS_PR_GEN_001 dependencies on IGS_PR_S_PRG_CONF

Line 570: FROM IGS_PR_S_PRG_CONF sprgcc

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