DBA Data[Home] [Help]

APPS.IGS_RE_VAL_DMS dependencies on IGS_RE_DFLT_MS_SET

Line 4: -- To validate IGS_RE_DFLT_MS_SET uniqueness

1: PACKAGE BODY IGS_RE_VAL_DMS AS
2: /* $Header: IGSRE08B.pls 115.3 2002/11/29 03:28:28 nsidana ship $ */
3: --
4: -- To validate IGS_RE_DFLT_MS_SET uniqueness
5: FUNCTION RESP_VAL_DMS_UNIQ(
6: p_course_cd IN VARCHAR2 ,
7: p_version_number IN NUMBER ,
8: p_attendance_type IN VARCHAR2 ,

Line 26: FROM IGS_RE_DFLT_MS_SET dms

22: dms.attendance_type,
23: dms.milestone_type,
24: dms.offset_days,
25: count('x') duplicate_count
26: FROM IGS_RE_DFLT_MS_SET dms
27: WHERE course_cd = p_course_cd AND
28: dms.version_number = p_version_number AND
29: dms.attendance_type = p_attendance_type
30: GROUP BY