APPS.IGS_EN_SEVIS dependencies on IGS_PE_VISA_V

Line 538: FROM igs_pe_visa_v

534: AND form_status = 'A';
535:
536: CURSOR c_visa_type IS
537: SELECT visa_type
538: FROM igs_pe_visa_v
539: WHERE person_id = p_person_id
540: AND visa_issue_date <= sysdate
541: AND sysdate <= visa_expiry_date ;
542:

Line 543: l_visa_type igs_pe_visa_v.visa_type%TYPE;

539: WHERE person_id = p_person_id
540: AND visa_issue_date <= sysdate
541: AND sysdate <= visa_expiry_date ;
542:
543: l_visa_type igs_pe_visa_v.visa_type%TYPE;
544:
545: BEGIN
546:
547: l_visa_type := NULL;

Line 587: l_visa_type IGS_PE_VISA_V.VISA_TYPE%TYPE;

583: CURSOR c_get_auth_rec_dur(cp_no_of_months NUMBER) IS
584: SELECT add_months(TRUNC(p_start_date ),cp_no_of_months) final_dt
585: FROM DUAL;
586: c_get_auth_rec_dur_rec c_get_auth_rec_dur%ROWTYPE;
587: l_visa_type IGS_PE_VISA_V.VISA_TYPE%TYPE;
588: l_status BOOLEAN;
589:
590: BEGIN
591:

Line 766: l_visa_type IGS_PE_VISA_V.VISA_TYPE%TYPE;

762: AND sequence_number = p_ci_sequence_number;
763:
764:
765: l_no_of_months NUMBER;
766: l_visa_type IGS_PE_VISA_V.VISA_TYPE%TYPE;
767: l_ci_start_Dt DATE;
768: l_ci_end_dt DATE;
769: l_duration_dt DATE;
770: l_temp_date DATE;