DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_ADDRESSES

Line 4411: from per_addresses

4407: and ppf.person_type_id = ppt.person_type_id;
4408: --
4409: cursor csr_address(c_person_id number, c_date_from date) is
4410: select address_id
4411: from per_addresses
4412: where person_id = c_person_id
4413: and date_from = c_date_from;
4414: --
4415: cursor csr_get_other(c_business_group_id number) is

Line 4454: update per_addresses

4450: --
4451:
4452: for l_address_id in csr_address(p_person_id, l_per_rec.effective_start_date)
4453: loop
4454: update per_addresses
4455: set date_from = p_cov_date_start
4456: where address_id = l_address_id.address_id;
4457: end loop;
4458: --