430: into dummy
431: from dual
432: where not exists(
433: select 1
434: from pay_personal_payment_methods_f ppm
435: where ppm.org_payment_method_id = opm_id
436: and ppm.effective_end_date > fnd_date.canonical_to_date(val_start_date));
437: --
438: if dummy = 1 then
649: into duplicate
650: from sys.dual
651: where not exists(
652: select 1
653: from pay_personal_payment_methods_f ppm
654: where ppm.assignment_id = assignment
655: and ppm.priority = in_priority
656: and fnd_date.canonical_to_date(val_start_date) < ppm.effective_end_date
657: and fnd_date.canonical_to_date(val_end_date) > ppm.effective_start_date);