APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_ADDRESSES

Line 1384: from per_addresses addr

1380: NVL(addr.telephone_number_1, ' ' ) telephone_number_1 ,
1381: NVL(addr.telephone_number_2, ' ' ) telephone_number_2 ,
1382: NVL(addr.telephone_number_3, ' ' ) telephone_number_3 ,
1383: NVL(addr.postal_code , ' ' ) postal_code
1384: from per_addresses addr
1385: where addr.person_id = p_per_assign_id
1386: and addr.primary_flag = 'Y'
1387: and NVL(addr.address_type,' ') <> 'PHCA'
1388: and addr.date_from = (select MAX(date_From)

Line 1389: from per_addresses

1385: where addr.person_id = p_per_assign_id
1386: and addr.primary_flag = 'Y'
1387: and NVL(addr.address_type,' ') <> 'PHCA'
1388: and addr.date_from = (select MAX(date_From)
1389: from per_addresses
1390: where person_id = p_per_assign_id
1391: and primary_flag = 'Y'
1392: and NVL(address_type,' ') <> 'PHCA');
1393:

Line 1869: from per_addresses addr

1865: NVL(addr.town_or_city,' ' ) non_us_city,
1866: NVL(addr.region_1,' ' ) non_us_region,
1867: NVL(addr.region_2,' ' ) non_us_region_postal_cd,
1868: NVL(addr.country, ' ' ) non_us_cc
1869: from per_addresses addr
1870: where addr.person_id = p_person_id
1871: and addr.address_type = 'PHCA'
1872: and addr.date_from = (select MAX(date_from)
1873: from per_addresses

Line 1873: from per_addresses

1869: from per_addresses addr
1870: where addr.person_id = p_person_id
1871: and addr.address_type = 'PHCA'
1872: and addr.date_from = (select MAX(date_from)
1873: from per_addresses
1874: where person_id = p_person_id
1875: and address_type = 'PHCA'
1876: )
1877: and rownum < 2;

Line 1883: from per_addresses addr

1879: /* Original cursor
1880: cursor c_non_us_address_cur(p_person_id in number ,
1881: p_effective_date in date ) is
1882: select NVL(addr.country, ' ') non_us_cc
1883: from per_addresses addr
1884: where addr.person_id = p_person_id
1885: and addr.address_type = 'PHCA'
1886: and NVL(addr.date_from, p_effective_date) <= TO_DATE(('12/31/' ||
1887: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 1891: from per_addresses

1887: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
1888: and NVL(addr.date_to, p_effective_date) >= TO_DATE(('01/01/' ||
1889: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')
1890: and NVL(addr.date_from, p_effective_date) = (select MAX(date_from)
1891: from per_addresses
1892: where person_id = p_person_id
1893: and NVL(date_from, p_effective_date) <=
1894: TO_DATE(('12/31/' ||
1895: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY'))