1066: CURSOR FV_jes IS
1067: SELECT sum (nvl (accounted_dr, 0)) -
1068: sum (nvl (accounted_cr, 0)) FV_total
1069: , gps.period_name
1070: FROM gl_je_lines gjl
1071: , gl_je_headers gjh
1072: , gl_period_statuses gps
1073: WHERE gjh.status = 'P'
1074: AND gjh.ledger_id = p_set_of_books_id