APPS.HR_PERSON_DELETE dependencies on PER_ROLES

Line 1449: from per_roles

1445: where person_id = p_person_id;
1446: --
1447: cursor ROLES is
1448: select role_id, object_version_number
1449: from per_roles
1450: where person_id= p_person_id;
1451:
1452: cursor c_ptu is
1453: select distinct person_type_usage_id

Line 1472: v_ovn_roles per_roles.object_version_number%TYPE;

1468: v_disability_id per_disabilities_f.disability_id%TYPE;
1469: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1470: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1471: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1472: v_ovn_roles per_roles.object_version_number%TYPE;
1473: v_role_id per_roles.role_id%TYPE;
1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;

Line 1473: v_role_id per_roles.role_id%TYPE;

1469: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1470: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1471: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1472: v_ovn_roles per_roles.object_version_number%TYPE;
1473: v_role_id per_roles.role_id%TYPE;
1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;