TRIGGER: APPS.PAY_RUN_RESULTS_BRD

Source

Description

pay_run_results_brd
   before delete
   on     pay_run_results
   for each row

Type

BEFORE EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
if hr_general.g_data_migrator_mode <> 'Y' then
   hr_utility.set_location('pay_run_results_brd',1);
   delete from pay_run_result_values RRV
   where  RRV.run_result_id = :OLD.run_result_id;
   hr_utility.set_location('pay_run_results_brd',2);
end if;
end pay_run_results_brd;