APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_ADDRESSES

Line 1403: FROM per_addresses addr

1399:
1400: /* Cursor for fetching person's Address */
1401: CURSOR csr_p_address_data (l_person_id number,l_date date) IS
1402: SELECT substr(addr.ADDRESS_LINE1 || ' ' ||addr.address_line2,1,120)
1403: FROM per_addresses addr
1404: WHERE addr.person_id = l_person_id
1405: AND l_date between addr.date_from and nvl(addr.date_to,to_date('31-12-4712','dd-mm-yyyy'))
1406: AND addr.primary_flag = 'Y';
1407: