APPS.HR_PERSON_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 631: from per_person_type_usages_f ptu

627: -- is already exists for the PTU table instead of per_all_people_f
628: l_old_person_type_id := null;
629: begin
630: select person_type_id into l_old_person_type_id
631: from per_person_type_usages_f ptu
632: where ptu.person_id=p_person_id
633: and ptu.person_type_id = p_person_type_id
634: and p_effective_date between ptu.effective_start_date
635: and ptu.effective_end_date;

Line 2110: ,per_person_type_usages_f ptu

2106: --for bug 7369431
2107: cursor chk_person_type is
2108: SELECT typ.system_person_type
2109: FROM per_person_types typ
2110: ,per_person_type_usages_f ptu
2111: WHERE typ.person_type_id = ptu.person_type_id
2112: AND p_effective_date BETWEEN ptu.effective_start_date
2113: AND ptu.effective_end_date
2114: AND ptu.person_id = p_person_id;

Line 2716: FROM per_person_type_usages_f

2712: AND trunc(sysdate) BETWEEN per.effective_start_date AND per.effective_end_date;
2713:
2714: CURSOR csr_ptu_details(c_person_id NUMBER) IS
2715: SELECT person_type_usage_id
2716: FROM per_person_type_usages_f
2717: WHERE person_id = c_person_id
2718: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date;
2719:
2720:

Line 2799: from per_person_type_usages_f ptuf, per_person_types ppt

2795: AND effective_start_date = start_date;
2796:
2797: BEGIN
2798: select 1 into l_exists
2799: from per_person_type_usages_f ptuf, per_person_types ppt
2800: where ppt.system_person_type = 'IRC_REG_USER'
2801: and ptuf.person_type_id = ppt.person_type_id
2802: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
2803: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)

Line 2861: , per_person_type_usages_f ptu

2857: select 'Y' into l_prev_exists
2858: from sys.dual where exists (
2859: select 'Previous Person type exists'
2860: from per_person_types ppt
2861: , per_person_type_usages_f ptu
2862: where ptu.person_id = p_source_person_id
2863: and ppt.business_group_id +0= l_bg_id
2864: and ptu.person_type_id = ppt.person_type_id
2865: and ppt.system_person_type <>'APL'

Line 2867: from per_person_type_usages_f ptu1,per_person_types ppt1

2863: and ppt.business_group_id +0= l_bg_id
2864: and ptu.person_type_id = ppt.person_type_id
2865: and ppt.system_person_type <>'APL'
2866: AND (ppt.system_person_type='OTHER' and not exists (select 1
2867: from per_person_type_usages_f ptu1,per_person_types ppt1
2868: where ptu1.person_id=p_source_person_id
2869: and ppt1.person_type_id=ptu1.person_type_id
2870: and ppt1.system_person_type='IRC_REG_USER') )
2871: and ppt.system_person_type<>'IRC_REG_USER'

Line 3212: from per_person_type_usages_f ptuf, per_person_types ppt

3208: END;
3209:
3210: BEGIN
3211: select 1 into l_can_exists
3212: from per_person_type_usages_f ptuf, per_person_types ppt
3213: where ppt.system_person_type = 'IRC_REG_USER'
3214: and ptuf.person_type_id = ppt.person_type_id
3215: and ppt.business_group_id + 0 = nvl(l_bg_id,ppt.business_group_id)
3216: and not exists (select null from per_all_assignments_f paaf where paaf.person_id = ptuf.person_id)