APPS.IGS_AD_GEN_007 dependencies on IGS_PE_PERSON_BASE_V

Line 20: FROM igs_pe_person_base_v

16: v_dd_mm_yyyy NUMBER(8);
17: CURSOR c_person IS
18: SELECT person_id,
19: first_name given_names
20: FROM igs_pe_person_base_v
21: WHERE last_name = p_surname AND
22: birth_date = TO_DATE(p_birth_dt, 'DDMMYYYY') AND
23: gender = p_sex;
24: BEGIN