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_DISABILITIES_F

Line 1985: FROM per_disabilities_f

1981: --
1982: CURSOR csr_disabilities IS
1983: SELECT disability_id, object_version_number,
1984: effective_start_date, effective_end_date
1985: FROM per_disabilities_f
1986: WHERE person_id = p_person_id;
1987: --
1988: CURSOR csr_roles IS
1989: SELECT role_id, object_version_number

Line 2022: l_disability_id per_disabilities_f.disability_id%TYPE;

2018: l_proposal_id number;
2019: l_review_cursor number;
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: --

Line 2023: l_object_version_no per_disabilities_f.object_version_number%TYPE;

2019: l_review_cursor number;
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;