221: ACCRUAL_PLAN_ID <> p_accrual_plan_id));
222: --
223: CURSOR dup_rec2 IS
224: select 'Y'
225: from PAY_ELEMENT_TYPES_F
226: where upper(ELEMENT_NAME) in
227: (upper(p_plan_name),
228: 'RESIDUAL ' || upper(p_plan_name),
229: 'CARRIED OVER ' || upper(p_plan_name));
913: l_effective_end_date,
914: '');
915: --
916: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',5);
917: delete from pay_element_types_f
918: where element_type_id = p_accrual_plan_element_type_id;
919: --
920: --
921: -- ...then the carried over element type...
939: l_effective_end_date,
940: '');
941: --
942: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',8);
943: delete from pay_element_types_f
944: where element_type_id = p_co_element_type_id;
945: --
946: --
947: -- ...then the residual element type.
965: l_effective_end_date,
966: '');
967: --
968: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 11);
969: delete from pay_element_types_f
970: where element_type_id = p_residual_element_type_id;
971: --
972: END pre_delete_actions;
973: --