APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_ADDRESSES

Line 1380: from per_addresses addr

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

Line 1385: from per_addresses

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

Line 1865: from per_addresses addr

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

Line 1869: from per_addresses

1865: from per_addresses addr
1866: where addr.person_id = p_person_id
1867: and addr.address_type = 'PHCA'
1868: and addr.date_from = (select MAX(date_from)
1869: from per_addresses
1870: where person_id = p_person_id
1871: and address_type = 'PHCA'
1872: )
1873: and rownum < 2;

Line 1879: from per_addresses addr

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

Line 1887: from per_addresses

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