APPS.HR_PERSON_INTERNAL dependencies on PER_ROLES

Line 2021: FROM per_roles

2017: WHERE person_id = p_person_id;
2018: --
2019: CURSOR csr_roles IS
2020: SELECT role_id, object_version_number
2021: FROM per_roles
2022: WHERE person_id= p_person_id;
2023: --
2024: CURSOR csr_ptu IS
2025: SELECT distinct person_type_usage_id

Line 2056: l_ovn_roles per_roles.object_version_number%TYPE;

2052: l_rows_processed number;
2053: l_incident_id per_work_incidents.person_id%TYPE;
2054: l_disability_id per_disabilities_f.disability_id%TYPE;
2055: l_object_version_no per_disabilities_f.object_version_number%TYPE;
2056: l_ovn_roles per_roles.object_version_number%TYPE;
2057: l_role_id per_roles.role_id%TYPE;
2058: --
2059: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
2060: l_effective_date date;

Line 2057: l_role_id per_roles.role_id%TYPE;

2053: l_incident_id per_work_incidents.person_id%TYPE;
2054: l_disability_id per_disabilities_f.disability_id%TYPE;
2055: l_object_version_no per_disabilities_f.object_version_number%TYPE;
2056: l_ovn_roles per_roles.object_version_number%TYPE;
2057: l_role_id per_roles.role_id%TYPE;
2058: --
2059: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
2060: l_effective_date date;
2061: l_object_version_number number;