APPS.IGS_GE_VAL_PARAM dependencies on IGS_AS_ASSESSMNT_ITM

Line 734: CURSOR c_ass(cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE)

730: RETURN BOOLEAN
731: AS
732: --
733: -- Local Cursors
734: CURSOR c_ass(cp_ass_id IGS_AS_ASSESSMNT_ITM.ass_id%TYPE)
735: IS
736: SELECT
737: TO_CHAR(asi.ass_id) || ' - ' ||
738: asi.description

Line 739: FROM IGS_AS_ASSESSMNT_ITM asi

735: IS
736: SELECT
737: TO_CHAR(asi.ass_id) || ' - ' ||
738: asi.description
739: FROM IGS_AS_ASSESSMNT_ITM asi
740: WHERE asi.ass_id = cp_ass_id;
741: --
742: -- Local Variables
743: v_ass_desc VARCHAR2(256) := NULL;