Line 785: igs_sv_util.get_program_dates(p_person_id,l_prgm_end_date,l_prgm_start_date);
781:
782: l_visa_type := get_visa_type(p_person_id, l_no_of_months);
783: l_interval := NUMTOYMINTERVAL(l_no_of_months,'month');
784: 785: igs_sv_util.get_program_dates(p_person_id,l_prgm_end_date,l_prgm_start_date); 786:
787:
788: IF l_prgm_start_date IS NOT NULL AND l_prgm_end_date IS NOT NULL
789: AND trunc(l_prgm_start_date) >= trunc(sysdate) THEN