APPS.IGS_PS_VAL_COO dependencies on IGS_EN_ATD_TYPE

Line 45: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;

41: FUNCTION crsp_val_coo_att(
42: p_attendance_type IN VARCHAR2 ,
43: p_message_name OUT NOCOPY VARCHAR2 )
44: RETURN BOOLEAN AS
45: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;
46: CURSOR c_attendance_type(
47: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE)IS
48: SELECT closed_ind
49: FROM IGS_EN_ATD_TYPE

Line 47: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE)IS

43: p_message_name OUT NOCOPY VARCHAR2 )
44: RETURN BOOLEAN AS
45: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;
46: CURSOR c_attendance_type(
47: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE)IS
48: SELECT closed_ind
49: FROM IGS_EN_ATD_TYPE
50: WHERE attendance_type = cp_attendance_type;
51: BEGIN

Line 49: FROM IGS_EN_ATD_TYPE

45: v_closed_ind IGS_EN_ATD_TYPE.closed_ind%TYPE;
46: CURSOR c_attendance_type(
47: cp_attendance_type IGS_EN_ATD_TYPE.attendance_type%TYPE)IS
48: SELECT closed_ind
49: FROM IGS_EN_ATD_TYPE
50: WHERE attendance_type = cp_attendance_type;
51: BEGIN
52: p_message_name := NULL;
53: OPEN c_attendance_type(