DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_MAGTAPE dependencies on PER_PEOPLE_EXTRA_INFO

Line 188: from per_people_extra_info pei

184: and ppas.action_status = 'C'
185: and ffis.user_entity_id = fdis.user_entity_id )))
186: and not exists
187: (select null
188: from per_people_extra_info pei
189: where pei.person_id = p.person_id
190: and pei.pei_information1 is not null
191: and pei.information_type = 'HR_IR21_PROCESSING_DATES_SG');
192: