DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_ADDRESSES

Line 2088: from per_addresses

2084: and ppf.person_type_id = ppt.person_type_id;
2085: --
2086: cursor csr_address(c_person_id number, c_date_from date) is
2087: select address_id
2088: from per_addresses
2089: where person_id = c_person_id
2090: and date_from = c_date_from;
2091: --
2092: cursor csr_get_other(c_business_group_id number) is

Line 2131: update per_addresses

2127: --
2128:
2129: for l_address_id in csr_address(p_person_id, l_per_rec.effective_start_date)
2130: loop
2131: update per_addresses
2132: set date_from = p_cov_date_start
2133: where address_id = l_address_id.address_id;
2134: end loop;
2135: --