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