APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 2654: from per_addresses

2650: , region_1
2651: , region_2
2652: , town_or_city
2653: , postal_code
2654: from per_addresses
2655: where person_id = p_person_id
2656: and l_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))
2657: and style = p_address_style
2658: and address_type = p_address_type;

Line 2686: from per_addresses

2682: , decode(region_2,'Y',null,address_line1) -- if flag = Y, then don't populate remaining postal address fields
2683: , decode(region_2,'Y',null,address_line2)
2684: , decode(region_2,'Y',null,address_line3)
2685: , decode(region_2,'Y',null,postal_code)
2686: from per_addresses
2687: where person_id = p_person_id
2688: and l_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))
2689: and style = 'ZA'
2690: and primary_flag = 'Y';