GL Fusion Balance Transfer - Full

SELECT track.system_id               SYSTEM_ID,
       track.group_id                GROUP_ID,
       track.status_code             STATUS_CODE,
       track.original_first_period   ORIGINAL_FIRST_PERIOD,
       track.xfer_request_id         REQUEST_ID,
       :P_BI_TRANSFER_MODE           TRANSFER_MODE,
       rel.target_ledger_name        FROM_LEDGER_NAME, 
       elgr.chart_of_accounts_id     FROM_COA_ID,
       flgr.name                     TO_LEDGER_NAME,
       :P_BI_FROM_PERIOD_NAME        FROM_PERIOD_NAME, 
       nvl(pmap.to_period_name,
           :P_BI_FROM_PERIOD_NAME)   TO_PERIOD_NAME,
       rel.target_currency_code      LEDGER_CURRENCY,
       coamap.name                   COA_MAPPING_NAME,
       calmap.name                   CALENDAR_MAPPING_NAME
FROM gl_xfr_tracking track,
     gl_ledger_relationships rel, gl_xfr_ledger_mappings lmap,
     gl_ledgers elgr,
     gl_xfr_ledgers flgr, gl_coa_mappings coamap,
     gl_xfr_calendar_mappings calmap, gl_xfr_period_mappings pmap
WHERE track.xfer_request_id = &g_request_id_str
AND   track.system_id = &g_system_id_str
AND   rel.target_ledger_short_name = :P_BI_FROM_LEDGER_SHORTNAME
AND   rel.application_id = 101
AND   rel.target_ledger_id = rel.source_ledger_id
AND   lmap.from_ledger_id = rel.target_ledger_id
AND   lmap.from_ledger_currency = rel.target_currency_code
AND   elgr.ledger_id = rel.target_ledger_id
AND   flgr.ledger_id = track.ledger_id
AND   coamap.coa_mapping_id(+) = lmap.coa_mapping_id
AND   calmap.calendar_mapping_id(+) = lmap.calendar_mapping_id
AND   pmap.calendar_mapping_id(+) = lmap.calendar_mapping_id
AND   pmap.from_period_name(+) = :P_BI_FROM_PERIOD_NAME