APPS.IGS_AV_VAL_ASULEB dependencies on IGS_GE_DATE

Line 32: IF (p_basis_year > TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4))) THEN

28: p_version_number IS NULL) THEN
29: RETURN TRUE;
30: END IF;
31: -- Validate that basis_year is not greater than the current year.(E)
32: IF (p_basis_year > TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4))) THEN
33: p_message_name := 'IGS_AV_LYENR_NOTGT_CURYR';
34: p_return_type := 'E';
35: RETURN FALSE;
36: END IF;

Line 46: TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) - v_qualification_recency) THEN

42: RAISE NO_DATA_FOUND;
43: END IF;
44: CLOSE c_qualification_recency;
45: IF (p_basis_year <
46: TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) - v_qualification_recency) THEN
47: p_message_name := 'IGS_AV_LRENR_OUTSIDE_QUALIFY';
48: p_return_type := 'W';
49: RETURN FALSE;
50: END IF;