APPS.PER_PEOPLE12_PKG dependencies on PER_PERSON_TYPES

Line 1403: FROM per_all_people_f per, per_person_types ppt

1399: IF p_effective_end_date <> hr_api.g_eot and l_create_apl <> 'Y' THEN
1400:
1401: SELECT ppt.system_person_type
1402: INTO l_next_person_type
1403: FROM per_all_people_f per, per_person_types ppt
1404: WHERE per.person_id = p_person_id
1405: AND per.person_type_id = ppt.person_type_id
1406: AND per.effective_start_date = p_effective_end_date + 1;
1407:

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 4404: from per_person_types ppt,

4400: );
4401: --
4402: cursor csr_per_type(c_person_id number, c_effective_date date) is
4403: select ppt.system_person_type
4404: from per_person_types ppt,
4405: per_all_people_f ppf
4406: where ppf.person_id = c_person_id
4407: and ppf.person_type_id = ppt.person_type_id;
4408: --

Line 4417: from per_person_types ppt

4413: and date_from = c_date_from;
4414: --
4415: cursor csr_get_other(c_business_group_id number) is
4416: select ppt.person_type_id
4417: from per_person_types ppt
4418: where ppt.business_group_id = c_business_group_id
4419: and ppt.default_flag = 'Y'
4420: and ppt.active_flag = 'Y'
4421: and ppt.system_person_type = 'OTHER';

Line 4479: from per_person_types ppt

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
4480: where ppt.system_person_type = 'OTHER');
4481: else
4482: hr_utility.set_location(l_proc,20);
4483: -- now change some of the fields before inserting precursor row

Line 4719: ,per_person_types ppt

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
4723: and ppt.system_person_type = 'EMP'