APPS.HR_PERSON_DELETE dependencies on PER_WORK_INCIDENTS

Line 1439: from per_work_incidents

1435: WHERE pma.person_id = p_person_id;
1436: --
1437: cursor WORK_INCIDENTS is
1438: select incident_id, object_version_number
1439: from per_work_incidents
1440: where person_id = p_person_id;
1441: --
1442: cursor DISABILITIES is
1443: select disability_id, object_version_number, effective_start_date, effective_end_date

Line 1466: v_incident_id per_work_incidents.person_id%TYPE;

1462: v_dummy number(3); /* Bug 941 591 and 4873360*/
1463: v_proposal_id number;
1464: v_review_cursor number;
1465: v_rows_processed number;
1466: v_incident_id per_work_incidents.person_id%TYPE;
1467: v_object_version_number per_work_incidents.object_version_number%TYPE;
1468: v_disability_id per_disabilities_f.disability_id%TYPE;
1469: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1470: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;

Line 1467: v_object_version_number per_work_incidents.object_version_number%TYPE;

1463: v_proposal_id number;
1464: v_review_cursor number;
1465: v_rows_processed number;
1466: v_incident_id per_work_incidents.person_id%TYPE;
1467: v_object_version_number per_work_incidents.object_version_number%TYPE;
1468: v_disability_id per_disabilities_f.disability_id%TYPE;
1469: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1470: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1471: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;