APPS.PAY_US_MMREF_LOCAL_XML dependencies on PER_PEOPLE_EXTRA_INFO

Line 959: select 'Y' from per_people_extra_info

955: and l_year between to_number(to_char(trunc(date_from,'yyyy'),'yyyy')) and to_number(nvl(to_char(trunc(date_to,'yyyy'),'yyyy') , '4712')));
956:
957:
958: cursor c_get_visa_details( p_person_id in number ) is
959: select 'Y' from per_people_extra_info
960: where person_id = p_person_id
961: and information_type = 'PER_US_VISA_DETAILS'
962: and pei_information_category = 'PER_US_VISA_DETAILS' ;
963: