APPS.IGS_EN_VAL_PAL dependencies on IGS_PE_PERSON_BASE_V

Line 8: --pkpatel 28-FEB-2003 Bug No. 2808871 .Modified IGS_PE_PERSON to IGS_PE_PERSON_BASE_V

4: --Change History:
5: --Who When What
6: --smadathi 25-AUG-2001 Bug No. 1956374 .The function GENP_VAL_STRT_END_DT removed
7: --smadathi 25-AUG-2001 Bug No. 1956374 .The function GENP_VAL_SDTT_SESS removed
8: --pkpatel 28-FEB-2003 Bug No. 2808871 .Modified IGS_PE_PERSON to IGS_PE_PERSON_BASE_V
9: -------------------------------------------------------------------------------------------
10:
11: -- Validate the IGS_PE_PERSON alias name and IGS_PE_TITLE
12: FUNCTION enrp_val_pal_alias(

Line 33: from igs_pe_person_base_v

29: CURSOR c_person IS
30: SELECT last_name surname,
31: first_name given_names,
32: title
33: from igs_pe_person_base_v
34: WHERE person_id = p_person_id;
35: BEGIN
36: -- at least one of the IGS_PE_PERSON_ALIAS.surname or given_names
37: -- must be set