APPS.IGS_AV_VAL_ASULEB dependencies on IGS_PS_VER

Line 17: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;

13: gv_other_detail VARCHAR2(255);
14: BEGIN -- advp_val_basis_year
15: -- validate the basis year
16: DECLARE
17: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;
18: CURSOR c_qualification_recency IS
19: SELECT qualification_recency
20: FROM IGS_PS_VER
21: WHERE course_cd = p_course_cd AND

Line 20: FROM IGS_PS_VER

16: DECLARE
17: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;
18: CURSOR c_qualification_recency IS
19: SELECT qualification_recency
20: FROM IGS_PS_VER
21: WHERE course_cd = p_course_cd AND
22: version_number = p_version_number;
23: BEGIN
24: p_message_name := null;