DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_WORK_INCIDENTS

Line 1979: FROM per_work_incidents

1975: WHERE pma.person_id = p_person_id;
1976: --
1977: CURSOR csr_work_incidents IS
1978: SELECT incident_id, object_version_number
1979: FROM per_work_incidents
1980: WHERE person_id = p_person_id;
1981: --
1982: CURSOR csr_disabilities IS
1983: SELECT disability_id, object_version_number,

Line 2021: l_incident_id per_work_incidents.person_id%TYPE;

2017: l_dummy number(3) := null; /* Bug 941 591 */
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;