DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE_SETUP dependencies on PER_PEOPLE_EXTRA_INFO

Line 103: from per_people_extra_info pei

99: -- Do not select the person if they have had an IR21 Form produced
100: ----------------------------------------------------------------------
101: and not exists
102: ( select null
103: from per_people_extra_info pei
104: where pei.person_id = a.person_id
105: and pei.pei_information1 is not null
106: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG'
107: )