APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_ADDRESSES

Line 2685: from per_addresses pa

2681: town_or_city,
2682: decode(country,'US',region_2,'CA',region_1,null),
2683: replace(postal_code,' '),
2684: country
2685: from per_addresses pa
2686: where pa.person_id = cp_person_id
2687: and pa.primary_flag = 'Y'
2688: and cp_date_earned between pa.date_from
2689: and nvl(pa.date_to, cp_date_earned);

Line 2701: from per_addresses pa

2697: town_or_city,
2698: decode(country,'US',region_2,'CA',region_1,null),
2699: replace(postal_code,' '),
2700: country
2701: from per_addresses pa
2702: where pa.person_id = cp_person_id
2703: and pa.primary_flag <> 'Y'
2704: and cp_date_earned between pa.date_from
2705: and nvl(pa.date_to, cp_date_earned)