9806:
9807: DELETE FROM xla_transfer_ledgers
9808: WHERE group_id IN
9809: (SELECT group_id
9810: FROM gl_je_batches
9811: WHERE status = 'P'
9812: AND default_period_name = p_period_name)
9813: AND (primary_ledger_id is null OR
9814: primary_ledger_id = p_ledger_id OR