APPS.PER_PEOPLE12_PKG dependencies on PER_PERSON_TYPE_USAGES_F

Line 355: select 'Y' from per_person_type_usages_f

351: where person_id = p_person_id
352: and date_received = p_date_end +1;
353:
354: cursor chk_fut_ex_apl(p_hire_date date) is
355: select 'Y' from per_person_type_usages_f
356: where person_id = p_person_id
357: and person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EX_APL')
358: and effective_start_date > p_hire_date;
359:

Line 2668: select 'Y' from per_person_type_usages_f

2664: and effective_start_date >= p_hire_date
2665: and assignment_type = 'A';
2666:
2667: cursor chk_future_pt is
2668: select 'Y' from per_person_type_usages_f
2669: where person_id = p_person_id
2670: and effective_start_date >= p_hire_date;
2671: --ER FPT
2672:

Line 4093: from per_person_type_usages_f ptu, per_person_types ppt

4089: -- ER FPT
4090: cursor fpt_future_exists
4091: is
4092: select 'Y'
4093: from per_person_type_usages_f ptu, per_person_types ppt
4094: where ptu.person_id = p_person_id
4095: and ptu.person_type_id = ppt.person_type_id
4096: and ptu.effective_start_date > p_effective_start_date
4097: and ppt.system_person_type in ('EMP','CWK');

Line 4475: update per_person_type_usages_f ptu

4471: where person_id = p_person_id;
4472: --
4473: -- Fix for bug 3390731 ends here.
4474: --
4475: update per_person_type_usages_f ptu
4476: set ptu.effective_start_date = p_cov_date_start
4477: where ptu.person_id = p_person_id
4478: and ptu.person_type_id in (select ppt.person_type_id
4479: from per_person_types ppt

Line 4682: insert into per_person_type_usages_f(

4678: select per_person_type_usages_s.nextval into l_ptu_nextval
4679: from sys.dual;
4680: l_object_version_number := 1;
4681: --
4682: insert into per_person_type_usages_f(
4683: PERSON_TYPE_USAGE_ID,
4684: PERSON_ID,
4685: PERSON_TYPE_ID,
4686: EFFECTIVE_START_DATE,

Line 4718: ,per_person_type_usages_f ptu

4714: --
4715: cursor csr_get_person(c_contact_person_id number) is
4716: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
4717: from per_contact_relationships ctr
4718: ,per_person_type_usages_f ptu
4719: ,per_person_types ppt
4720: where ctr.contact_person_id = c_contact_person_id
4721: and ctr.person_id = ptu.person_id
4722: and ptu.person_type_id = ppt.person_type_id