APPS.HR_PERSON_INTERNAL dependencies on PER_PERSON_TYPE_USAGES_F

Line 1879: delete from per_person_type_usages_f

1875: hr_utility.set_location(l_proc, 90);
1876: end if;
1877: --
1878: begin
1879: delete from per_person_type_usages_f
1880: where person_id = P_PERSON_ID;
1881: exception
1882: when NO_DATA_FOUND then null;
1883: end;

Line 1995: FROM per_person_type_usages_f ptu

1991: WHERE person_id= p_person_id;
1992: --
1993: CURSOR csr_ptu IS
1994: SELECT distinct person_type_usage_id
1995: FROM per_person_type_usages_f ptu
1996: WHERE ptu.person_id = p_person_id
1997: ORDER BY person_type_usage_id;
1998: --
1999: CURSOR csr_asg IS

Line 2027: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

2023: l_object_version_no per_disabilities_f.object_version_number%TYPE;
2024: l_ovn_roles per_roles.object_version_number%TYPE;
2025: l_role_id per_roles.role_id%TYPE;
2026: --
2027: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
2028: l_effective_date date;
2029: l_object_version_number number;
2030: l_effective_start_date date;
2031: l_effective_end_date date;

Line 3430: -- Add delete from per_person_type_usages_f

3426: --
3427: -- 03/18/98 Change Ends
3428: --
3429: -- 28/5/98
3430: -- Add delete from per_person_type_usages_f
3431: if g_debug then
3432: hr_utility.set_location(l_proc, 180);
3433: end if;
3434: --

Line 3439: from per_person_type_usages_f ptu1

3435: for ptu_rec in csr_ptu loop
3436: --
3437: select min(ptu1.effective_start_date)
3438: into l_effective_date
3439: from per_person_type_usages_f ptu1
3440: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
3441: --
3442: select ptu2.object_version_number
3443: into l_object_version_number

Line 3444: from per_person_type_usages_f ptu2

3440: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
3441: --
3442: select ptu2.object_version_number
3443: into l_object_version_number
3444: from per_person_type_usages_f ptu2
3445: where ptu2.person_type_usage_id = ptu_rec.person_type_usage_id
3446: and ptu2.effective_start_date = l_effective_date;
3447: --
3448: if g_debug then