APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_ADDRESSES

Line 1979: from per_addresses pa

1975: town_or_city,
1976: decode(country,'US',region_2,'CA',region_1,null),
1977: replace(postal_code,' '),
1978: country
1979: from per_addresses pa
1980: where pa.person_id = cp_person_id
1981: and pa.primary_flag = 'Y'
1982: and cp_date_earned between pa.date_from
1983: and nvl(pa.date_to, cp_date_earned);

Line 1995: from per_addresses pa

1991: town_or_city,
1992: decode(country,'US',region_2,'CA',region_1,null),
1993: replace(postal_code,' '),
1994: country
1995: from per_addresses pa
1996: where pa.person_id = cp_person_id
1997: and pa.primary_flag <> 'Y'
1998: and cp_date_earned between pa.date_from
1999: and nvl(pa.date_to, cp_date_earned)