APPS.IGS_PE_PERSON_SS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 1512: FROM igs_pe_person_base_v

1508:
1509: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
1510: IS
1511: SELECT birth_date
1512: FROM igs_pe_person_base_v
1513: WHERE person_id = cp_person_id;
1514:
1515: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
1516: v_mar_dt VARCHAR2(100);

Line 1515: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

1511: SELECT birth_date
1512: FROM igs_pe_person_base_v
1513: WHERE person_id = cp_person_id;
1514:
1515: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
1516: v_mar_dt VARCHAR2(100);
1517: v_other_dt VARCHAR2(100);
1518: l_marital_date DATE;
1519: l_ethnicity igs_pe_stat_v.ethnic_origin%TYPE;