APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_ADDRESSES

Line 1461: FROM per_addresses addr

1457:
1458: /* Cursor for fetching person's Address */
1459: CURSOR csr_p_address_data (l_person_id number,l_date date) IS
1460: SELECT substr(addr.ADDRESS_LINE1 || ' ' ||addr.address_line2,1,120)
1461: FROM per_addresses addr
1462: WHERE addr.person_id = l_person_id
1463: AND l_date between addr.date_from and nvl(addr.date_to,to_date('31-12-4712','dd-mm-yyyy'))
1464: AND addr.primary_flag = 'Y';
1465: