DBA Data[Home] [Help]

APPS.IGS_PE_PERS_DISABLTY_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 561: FROM igs_pe_person_base_v

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;
563:
564: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
565: BEGIN

Line 564: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

560: SELECT birth_date
561: FROM igs_pe_person_base_v
562: WHERE person_id = cp_person_id;
563:
564: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
565: BEGIN
566:
567: IF new_references.start_date > new_references.end_date THEN
568: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_FROM_DT_GRT_TO_DATE');