APPS.IGS_OR_VAL_INS dependencies on IGS_OR_INSTITUTION

Line 43: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS

39: v_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE;
40:
41: CURSOR c_person_stats (
42:
43: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
44:
45: SELECT ps.person_id
46:
47: FROM IGS_PE_STATISTICS ps

Line 53: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS

49: WHERE ps.prior_ug_inst = cp_institution_cd;
50:
51: CURSOR c_advanced_stand (
52:
53: cp_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
54:
55: SELECT advs.course_cd
56:
57: FROM IGS_AV_ADV_STANDING advs

Line 356: v_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE := NULL;

352:
353: p_message_name OUT NOCOPY VARCHAR2 )
354:
355: RETURN BOOLEAN AS
356: v_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE := NULL;
357: BEGIN
358: v_institution_cd := FND_PROFILE.VALUE('IGS_OR_LOCAL_INST');
359: IF (p_institution_cd <> NVL(v_institution_cd,'') ) THEN
360: RETURN FALSE;