DBA Data[Home] [Help]

APPS.IGS_PE_PERS_DISABLTY_PKG dependencies on IGS_PE_PASSPORT

Line 558: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)

554: OR ( NVL(cp_start_date,l_default_start_date) <= NVL(start_date,l_default_start_date) AND
555: NVL(end_date,l_default_end_date) <= NVL(cp_end_date,l_default_end_date))
556: );
557:
558: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
559: IS
560: SELECT birth_date
561: FROM igs_pe_person_base_v
562: WHERE person_id = cp_person_id;