APPS.HR_PERSON_DELETE dependencies on PER_DISABILITIES_F

Line 1443: from per_disabilities_f

1439: where person_id = p_person_id;
1440: --
1441: cursor DISABILITIES is
1442: select disability_id, object_version_number, effective_start_date, effective_end_date
1443: from per_disabilities_f
1444: where person_id = p_person_id;
1445: --
1446: cursor ROLES is
1447: select role_id, object_version_number

Line 1467: v_disability_id per_disabilities_f.disability_id%TYPE;

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

Line 1468: v_object_version_no per_disabilities_f.object_version_number%TYPE;

1464: v_rows_processed number;
1465: v_incident_id per_work_incidents.person_id%TYPE;
1466: v_object_version_number per_work_incidents.object_version_number%TYPE;
1467: v_disability_id per_disabilities_f.disability_id%TYPE;
1468: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1469: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1470: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1471: v_ovn_roles per_roles.object_version_number%TYPE;
1472: v_role_id per_roles.role_id%TYPE;

Line 1469: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;

1465: v_incident_id per_work_incidents.person_id%TYPE;
1466: v_object_version_number per_work_incidents.object_version_number%TYPE;
1467: v_disability_id per_disabilities_f.disability_id%TYPE;
1468: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1469: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1470: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1471: v_ovn_roles per_roles.object_version_number%TYPE;
1472: v_role_id per_roles.role_id%TYPE;
1473: --

Line 1470: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;

1466: v_object_version_number per_work_incidents.object_version_number%TYPE;
1467: v_disability_id per_disabilities_f.disability_id%TYPE;
1468: v_object_version_no per_disabilities_f.object_version_number%TYPE;
1469: v_effective_start_date per_disabilities_f.effective_start_date%TYPE;
1470: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1471: v_ovn_roles per_roles.object_version_number%TYPE;
1472: v_role_id per_roles.role_id%TYPE;
1473: --
1474: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;