476: into valid_del
477: from dual
478: where not exists(
479: select 1 480: from pay_payrolls_f pp 481: where pp.default_payment_method_id = opm_id
482: and pp.effective_end_date > fnd_date.canonical_to_date(val_start_date));
483: --
484: if valid_del = 'Y' then