APPS.PAY_CA_EMP_TAX_INF dependencies on PER_ADDRESSES

Line 21: PER_ADDRESSES pa,

17: cursor csr_get_resident_province is
18: select lkp.lookup_code,
19: lkp.meaning
20: from PER_ASSIGNMENTS_F paf,
21: PER_ADDRESSES pa,
22: HR_LOOKUPS lkp
23: where paf.assignment_id = p_assignment_id
24: and p_session_date between paf.effective_start_date and
25: paf.effective_end_date

Line 909: from per_addresses addr

905: select substr(addr.address_line1,1,37) ,
906: substr(addr.address_line2,1,37) ,
907: substr(addr.address_line3,1,37) ,
908: rtrim(substr(addr.town_or_city,1,23)) ||' '||addr.region_1||' '||addr.postal_code
909: from per_addresses addr
910: WHERE addr.person_id = p_person_id
911: AND addr.primary_flag = 'Y'
912: AND p_effective_date between
913: addr.date_from and nvl(addr.date_to, p_effective_date);