APPS.PAY_AE_SI_REPORTS dependencies on PER_ADDRESSES

Line 256: FROM per_addresses addr

252:
253: /* Cursor for fetching person's Address */
254: CURSOR csr_p_address_data (l_person_id number,l_effective_date date) IS
255: SELECT substr(addr.ADDRESS_LINE1 || ' ' ||addr.address_line2,1,60)
256: FROM per_addresses addr
257: WHERE addr.person_id = l_person_id
258: AND l_effective_date between addr.date_from and nvl(addr.date_to,to_date('31-12-4712','dd-mm-yyyy'))
259: AND addr.primary_flag = 'Y';
260:

Line 1260: FROM per_addresses addr

1256:
1257: /* Cursor for fetching person's Address */
1258: CURSOR csr_p_address_data (l_person_id number,l_effective_date date) IS
1259: SELECT substr(addr.ADDRESS_LINE1 || ' ' ||addr.address_line2,1,60)
1260: FROM per_addresses addr
1261: WHERE addr.person_id = l_person_id
1262: AND l_effective_date between addr.date_from and nvl(addr.date_to,to_date('31-12-4712','dd-mm-yyyy'))
1263: AND addr.primary_flag = 'Y';
1264: