APPS.PAY_US_MMREF_LOCAL_XML dependencies on PER_ADDRESSES

Line 951: ( select person_id from per_addresses

947:
948: cursor c_get_non_pa_emp_det( p_person_id in number ) is
949: select 'Y' from dual
950: where not exists
951: ( select person_id from per_addresses
952: where person_id = p_person_id
953: and region_2 = 'PA'
954: and primary_flag = 'Y'
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')));