eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_INTERNAL dependencies on PER_ROLES

Line 1990: FROM per_roles

1986: WHERE person_id = p_person_id;
1987: --
1988: CURSOR csr_roles IS
1989: SELECT role_id, object_version_number
1990: FROM per_roles
1991: WHERE person_id= p_person_id;
1992: --
1993: CURSOR csr_ptu IS
1994: SELECT distinct person_type_usage_id

Line 2024: l_ovn_roles per_roles.object_version_number%TYPE;

2020: l_rows_processed number;
2021: l_incident_id per_work_incidents.person_id%TYPE;
2022: l_disability_id per_disabilities_f.disability_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;

Line 2025: l_role_id per_roles.role_id%TYPE;

2021: l_incident_id per_work_incidents.person_id%TYPE;
2022: l_disability_id per_disabilities_f.disability_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;