APPS.IGS_PS_VAL_CRV dependencies on IGS_PS_GOVT_SPL_TYPE

Line 16: v_closed_ind IGS_PS_GOVT_SPL_TYPE.closed_ind%TYPE;

12: FUNCTION crsp_val_crv_gsct(
13: p_govt_special_course_type IN VARCHAR2 ,
14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: v_closed_ind IGS_PS_GOVT_SPL_TYPE.closed_ind%TYPE;
17: CURSOR c_govt_special_course_type IS
18: SELECT closed_ind
19: FROM IGS_PS_GOVT_SPL_TYPE
20: WHERE govt_special_course_type = p_govt_special_course_type;

Line 19: FROM IGS_PS_GOVT_SPL_TYPE

15: RETURN BOOLEAN AS
16: v_closed_ind IGS_PS_GOVT_SPL_TYPE.closed_ind%TYPE;
17: CURSOR c_govt_special_course_type IS
18: SELECT closed_ind
19: FROM IGS_PS_GOVT_SPL_TYPE
20: WHERE govt_special_course_type = p_govt_special_course_type;
21: BEGIN
22: OPEN c_govt_special_course_type;
23: FETCH c_govt_special_course_type INTO v_closed_ind;

Line 439: -- Validate that IGS_PS_GOVT_SPL_TYPE is not closed

435: p_version_number,
436: p_message_name) = FALSE) THEN
437: RETURN FALSE;
438: END IF;
439: -- Validate that IGS_PS_GOVT_SPL_TYPE is not closed
440: IF (IGS_PS_VAL_CRV.crsp_val_crv_gsct(
441: v_cv_rec.govt_special_course_type,
442: p_message_name) = FALSE) THEN
443: RETURN FALSE;