DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_WPM_PLAN_HIERARCHY

Line 7234: DELETE per_wpm_plan_hierarchy

7230: p_no_life_events_warning => l_dummy
7231: );
7232:
7233: --remove the plan details from hierarchy table as plan is rolled back.
7234: DELETE per_wpm_plan_hierarchy
7235: WHERE plan_id = p_plan_id;
7236:
7237: --remove the plan details from Appraisal Summary table as plan is rolled back.
7238: DELETE per_wpm_appraisal_summary

Line 8093: DELETE FROM per_wpm_plan_hierarchy

8089: delete_appraisal_for_person (k.appraisal_id, k.object_version_number);
8090: END LOOP;
8091:
8092: -- remove the node from the hierarchy
8093: DELETE FROM per_wpm_plan_hierarchy
8094: WHERE employee_person_id = j.person_id;
8095:
8096: --
8097: l_person_id := j.person_id;