DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PE_PERSON_ALIAS_V

Line 994: FROM igs_pe_person_alias_v

990: ***************************************************************/
991: -- smaddali modified this cursor to get records which are effective in the HESA submission period, bug#3235753
992: CURSOR c_fmly_nm IS
993: SELECT surname
994: FROM igs_pe_person_alias_v
995: WHERE person_id = p_person_id
996: AND alias_type = 'SNAME16'
997: AND ( Start_Dt IS NULL OR Start_Dt <= p_enrl_end_dt )
998: AND ( End_Dt IS NULL OR End_Dt >= p_enrl_start_dt )