APPS.PER_US_VETS_100A_LIST_PKG dependencies on PER_PEOPLE_EXTRA_INFO
Line 11: from PER_PEOPLE_EXTRA_INFO ppei where
7: is
8: l_count number;
9: begin
10: select count(person_id) into l_count 11: from PER_PEOPLE_EXTRA_INFO ppei where 12: l_person_id = ppei.person_id
13: and ppei.information_type ='VETS 100A'
14: and pei_information1 is not null
15: and