DBA Data[Home] [Help]

APPS.PER_VETS_MAG_100A_REPORT dependencies on PER_PEOPLE_EXTRA_INFO

Line 186: from PER_PEOPLE_EXTRA_INFO ppei where

182: is
183: l_count number;
184: begin
185: select count(person_id) into l_count
186: from PER_PEOPLE_EXTRA_INFO ppei where
187: l_person_id = ppei.person_id
188: and ppei.information_type ='VETS 100A'
189: and pei_information1 is not null
190: and