APPS.IGS_PE_VISIT_HISTRY_PKG dependencies on IGS_PE_VISIT_HISTRY_V

Line 417: FROM igs_pe_visit_histry_v a ,igs_pe_visit_histry_v b

413: ----------------------------------------------------------------------------------------------
414:
415: CURSOR c_visit_hist_overlap(cp_person_id igs_pe_visa.person_id%TYPE) IS
416: SELECT count(1)
417: FROM igs_pe_visit_histry_v a ,igs_pe_visit_histry_v b
418: WHERE a.person_id = cp_person_id AND
419: a.person_id = b.person_id AND
420: a.row_id <> b.row_id AND
421: NVL(a.visit_end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) >= b.visit_start_date AND

Line 424: CURSOR person_id_cur(cp_visa_id igs_pe_visit_histry.visa_id%TYPE) IS

420: a.row_id <> b.row_id AND
421: NVL(a.visit_end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) >= b.visit_start_date AND
422: NVL(a.visit_end_date,TO_DATE('4712/12/31','YYYY/MM/DD')) <= NVL(b.visit_end_date,TO_DATE('4712/12/31','YYYY/MM/DD'));
423:
424: CURSOR person_id_cur(cp_visa_id igs_pe_visit_histry.visa_id%TYPE) IS
425: SELECT person_id
426: FROM igs_pe_visa
427: WHERE visa_id = cp_visa_id;
428: