481: into valid_del
482: from dual
483: where not exists(
484: select 1 485: from pay_payrolls_f pp 486: where pp.default_payment_method_id = opm_id
487: and pp.effective_end_date > fnd_date.canonical_to_date(val_start_date));
488: --
489: if valid_del = 'Y' then