eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AV_GEN_001 dependencies on IGS_PS_VER

Line 1984: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;

1980: gv_other_detail VARCHAR2(255);
1981: BEGIN -- advp_val_basis_year
1982: -- validate the basis year
1983: DECLARE
1984: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;
1985: CURSOR c_qualification_recency IS
1986: SELECT qualification_recency
1987: FROM IGS_PS_VER
1988: WHERE course_cd = p_course_cd AND

Line 1987: FROM IGS_PS_VER

1983: DECLARE
1984: v_qualification_recency IGS_PS_VER.qualification_recency%TYPE;
1985: CURSOR c_qualification_recency IS
1986: SELECT qualification_recency
1987: FROM IGS_PS_VER
1988: WHERE course_cd = p_course_cd AND
1989: version_number = p_version_number;
1990: BEGIN
1991: p_message_name := null;