DBA Data[Home] [Help]

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