342: settlement_date
343: FROM fun_net_batches_all
344: WHERE batch_id = p_batch_id;
345:
346: l_ledger_id gl_ledgers.ledger_id%TYPE;
347: l_ledger_name gl_ledgers.name%TYPE;
348: x_closing_status gl_period_statuses.closing_status%TYPE;
349: x_period_year gl_period_statuses.period_year%TYPE;
350: x_period_num gl_period_statuses.period_num%TYPE;
343: FROM fun_net_batches_all
344: WHERE batch_id = p_batch_id;
345:
346: l_ledger_id gl_ledgers.ledger_id%TYPE;
347: l_ledger_name gl_ledgers.name%TYPE;
348: x_closing_status gl_period_statuses.closing_status%TYPE;
349: x_period_year gl_period_statuses.period_year%TYPE;
350: x_period_num gl_period_statuses.period_num%TYPE;
351: x_period_type gl_period_statuses.period_type%TYPE;