1131:
1132: -------------------------------------------------
1133: select fa_transaction_headers_s.nextval
1134: into X_Transaction_Header_Id
1135: from sys.dual;
1136: -------------------------------------------------
1137: select greatest(calendar_period_open_date,
1138: least(sysdate, calendar_period_close_date)),
1139: calendar_period_open_date,