10503: FROM (
10504: SELECT xet.event_id event_id
10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10504: SELECT xet.event_id event_id
10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10505: , 0 line_number
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10506: , CASE r
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10507: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10508: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10509: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10510: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10511: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10512: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10513: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10514: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10515: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10516: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10517: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10518: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10519: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10520: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10521: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10522: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10523: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10524: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10525: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10526: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10527: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null
10528: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null
10536: END object_name
10529: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
10530: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
10531: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
10532: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
10533: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
10534:
10535: ELSE null
10536: END object_name
10537: , CASE r
10664:
10665: ELSE null
10666: END source_meaning
10667: FROM xla_events_gt xet
10668: , CE_XLA_EXT_HEADERS_V h1
10669: , fnd_lookup_values fvl22
10670: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
10671: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10672: AND xet.event_type_code = C_EVENT_TYPE_CODE
10807: --
10808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10809: --
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10810:
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10811: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10812: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10813: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10814: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10815: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10816: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10817: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10818: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10819: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10820: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10821: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10822: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10823: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10824: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10825: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10826: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10827: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10828: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10829: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10830: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10831: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:
10832: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:
10840: l_array_source_3 t_array_source_3;
10833: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
10834: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
10835: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
10836: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10837: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
10838:
10839:
10840: l_array_source_3 t_array_source_3;
10841: l_array_source_4 t_array_source_4;
10925: , h1.CF_EXCHANGE_RATE source_27
10926: , h1.CF_EXCHANGE_RATE_TYPE source_28
10927: , h1.ACCOUNTING_DATE source_29
10928: FROM xla_events_gt xet
10929: , CE_XLA_EXT_HEADERS_V h1
10930: , fnd_lookup_values fvl22
10931: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10932: and xet.event_type_code = C_EVENT_TYPE_CODE
10933: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
11909: FROM (
11910: SELECT xet.event_id event_id
11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11910: SELECT xet.event_id event_id
11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11911: , 0 line_number
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11912: , CASE r
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11913: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11914: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11915: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11916: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11917: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11918: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11919: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11920: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11921: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11922: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11923: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11924: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11925: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11926: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11927: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11928: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11929: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11930: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11931: WHEN 19 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11932: WHEN 20 THEN 'CE_XLA_EXT_HEADERS_V'
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11933: WHEN 21 THEN 'CE_XLA_EXT_HEADERS_V'
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null
11934: WHEN 22 THEN 'CE_XLA_EXT_HEADERS_V'
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null
11942: END object_name
11935: WHEN 23 THEN 'CE_XLA_EXT_HEADERS_V'
11936: WHEN 24 THEN 'CE_XLA_EXT_HEADERS_V'
11937: WHEN 25 THEN 'CE_XLA_EXT_HEADERS_V'
11938: WHEN 26 THEN 'CE_XLA_EXT_HEADERS_V'
11939: WHEN 27 THEN 'CE_XLA_EXT_HEADERS_V'
11940:
11941: ELSE null
11942: END object_name
11943: , CASE r
12070:
12071: ELSE null
12072: END source_meaning
12073: FROM xla_events_gt xet
12074: , CE_XLA_EXT_HEADERS_V h1
12075: , fnd_lookup_values fvl22
12076: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
12077: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12078: AND xet.event_type_code = C_EVENT_TYPE_CODE
12213: --
12214: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12214: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12215: --
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12216:
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12217: TYPE t_array_source_3 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12218: TYPE t_array_source_4 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_BANK_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12219: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12220: TYPE t_array_source_6 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_FX_CHARGE_CCID%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12221: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12222: TYPE t_array_source_8 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12223: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12224: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12225: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12226: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12227: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12228: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12229: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12230: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12231: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12232: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12233: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12234: TYPE t_array_source_20 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_ERROR_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12235: TYPE t_array_source_21 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_FX_CHARGE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12236: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12237: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:
12238: TYPE t_array_source_24 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:
12246: l_array_source_3 t_array_source_3;
12239: TYPE t_array_source_25 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
12240: TYPE t_array_source_26 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
12241: TYPE t_array_source_27 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
12242: TYPE t_array_source_28 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
12243: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
12244:
12245:
12246: l_array_source_3 t_array_source_3;
12247: l_array_source_4 t_array_source_4;
12331: , h1.CF_EXCHANGE_RATE source_27
12332: , h1.CF_EXCHANGE_RATE_TYPE source_28
12333: , h1.ACCOUNTING_DATE source_29
12334: FROM xla_events_gt xet
12335: , CE_XLA_EXT_HEADERS_V h1
12336: , fnd_lookup_values fvl22
12337: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12338: and xet.event_type_code = C_EVENT_TYPE_CODE
12339: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
13315: FROM (
13316: SELECT xet.event_id event_id
13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13316: SELECT xet.event_id event_id
13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13317: , 0 line_number
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13318: , CASE r
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13319: WHEN 1 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13320: WHEN 2 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13321: WHEN 3 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13322: WHEN 4 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13323: WHEN 5 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13324: WHEN 6 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13325: WHEN 7 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13326: WHEN 8 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13327: WHEN 9 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13328: WHEN 10 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13329: WHEN 11 THEN 'CE_XLA_EXT_HEADERS_V'
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13330: WHEN 12 THEN 'CE_XLA_EXT_HEADERS_V'
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null
13331: WHEN 13 THEN 'CE_XLA_EXT_HEADERS_V'
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null
13339: END object_name
13332: WHEN 14 THEN 'CE_XLA_EXT_HEADERS_V'
13333: WHEN 15 THEN 'CE_XLA_EXT_HEADERS_V'
13334: WHEN 16 THEN 'CE_XLA_EXT_HEADERS_V'
13335: WHEN 17 THEN 'CE_XLA_EXT_HEADERS_V'
13336: WHEN 18 THEN 'CE_XLA_EXT_HEADERS_V'
13337:
13338: ELSE null
13339: END object_name
13340: , CASE r
13431:
13432: ELSE null
13433: END source_meaning
13434: FROM xla_events_gt xet
13435: , CE_XLA_EXT_HEADERS_V h1
13436: , fnd_lookup_values fvl22
13437: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
13438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13439: AND xet.event_class_code = C_EVENT_CLASS_CODE
13575: --
13576: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13576: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13577: --
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13578:
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13579: TYPE t_array_source_1 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_REFERENCE_TEXT%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13580: TYPE t_array_source_2 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13581: TYPE t_array_source_5 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CASH_ACCT_CCID%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13582: TYPE t_array_source_7 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_OFFSET_CCID%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13583: TYPE t_array_source_9 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13584: TYPE t_array_source_10 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_NUMBER%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13585: TYPE t_array_source_11 IS TABLE OF CE_XLA_EXT_HEADERS_V.CASHFLOW_HIST_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13586: TYPE t_array_source_12 IS TABLE OF CE_XLA_EXT_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13587: TYPE t_array_source_13 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_BA_CURRENCY%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13588: TYPE t_array_source_14 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13589: TYPE t_array_source_15 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13590: TYPE t_array_source_16 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_EXC_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:
13591: TYPE t_array_source_17 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:
13599: l_array_source_1 t_array_source_1;
13592: TYPE t_array_source_18 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
13593: TYPE t_array_source_19 IS TABLE OF CE_XLA_EXT_HEADERS_V.REVERSAL_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
13594: TYPE t_array_source_22 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_DIRECTION%TYPE INDEX BY BINARY_INTEGER;
13595: TYPE t_array_source_23 IS TABLE OF CE_XLA_EXT_HEADERS_V.CF_CLEARED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
13596: TYPE t_array_source_29 IS TABLE OF CE_XLA_EXT_HEADERS_V.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
13597:
13598:
13599: l_array_source_1 t_array_source_1;
13600: l_array_source_2 t_array_source_2;
13665: , fvl22.meaning source_22_meaning
13666: , h1.CF_CLEARED_AMOUNT source_23
13667: , h1.ACCOUNTING_DATE source_29
13668: FROM xla_events_gt xet
13669: , CE_XLA_EXT_HEADERS_V h1
13670: , fnd_lookup_values fvl22
13671: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13672: and xet.event_class_code = C_EVENT_CLASS_CODE
13673: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id