APPS.PER_PEOPLE12_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 2152: update per_person_type_usages_f ptu

2148: where person_id = p_person_id;
2149: --
2150: -- Fix for bug 3390731 ends here.
2151: --
2152: update per_person_type_usages_f ptu
2153: set ptu.effective_start_date = p_cov_date_start
2154: where ptu.person_id = p_person_id
2155: and ptu.person_type_id in (select ppt.person_type_id
2156: from per_person_types ppt

Line 2359: insert into per_person_type_usages_f(

2355: select per_person_type_usages_s.nextval into l_ptu_nextval
2356: from sys.dual;
2357: l_object_version_number := 1;
2358: --
2359: insert into per_person_type_usages_f(
2360: PERSON_TYPE_USAGE_ID,
2361: PERSON_ID,
2362: PERSON_TYPE_ID,
2363: EFFECTIVE_START_DATE,

Line 2395: ,per_person_type_usages_f ptu

2391: --
2392: cursor csr_get_person(c_contact_person_id number) is
2393: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
2394: from per_contact_relationships ctr
2395: ,per_person_type_usages_f ptu
2396: ,per_person_types ppt
2397: where ctr.contact_person_id = c_contact_person_id
2398: and ctr.person_id = ptu.person_id
2399: and ptu.person_type_id = ppt.person_type_id