DBA Data[Home] [Help]

APPS.PAY_ACCRUAL_PLANS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 225: from PAY_ELEMENT_TYPES_F

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));

Line 917: delete from pay_element_types_f

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...

Line 943: delete from pay_element_types_f

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.

Line 969: delete from pay_element_types_f

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: --