DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_WORK_INCIDENTS

Line 2010: FROM per_work_incidents

2006: WHERE pma.person_id = p_person_id;
2007: --
2008: CURSOR csr_work_incidents IS
2009: SELECT incident_id, object_version_number
2010: FROM per_work_incidents
2011: WHERE person_id = p_person_id;
2012: --
2013: CURSOR csr_disabilities IS
2014: SELECT disability_id, object_version_number,

Line 2053: l_incident_id per_work_incidents.person_id%TYPE;

2049: l_dummy number(3) := null; /* Bug 941 591 */
2050: l_proposal_id number;
2051: l_review_cursor number;
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;