DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_WPM_PLAN_HIERARCHY

Line 5434: delete PER_WPM_PLAN_HIERARCHY

5430: ,p_status_code => l_status_code
5431: ,p_duplicate_name_warning => l_dummy
5432: ,p_no_life_events_warning => l_dummy);
5433: --remove the plan details from hierarchy table as plan is rolled back.
5434: delete PER_WPM_PLAN_HIERARCHY
5435: where PLAN_ID = p_plan_id;
5436: --remove the plan details from Appraisal Summary table as plan is rolled back.
5437: delete PER_WPM_APPRAISAL_SUMMARY
5438: where PLAN_ID = p_plan_id;

Line 6128: FROM per_wpm_plan_hierarchy

6124: delete_appraisal_for_person(k.appraisal_id,k.object_version_number);
6125: END LOOP;
6126: -- remove the node from the hierarchy
6127: DELETE
6128: FROM per_wpm_plan_hierarchy
6129: WHERE employee_person_id = j.person_id;
6130: --
6131: l_person_id := j.person_id;
6132: END LOOP;