150428: FROM (
150429: SELECT xet.event_id event_id
150430: , 0 line_number
150431: , CASE r
150432: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150429: SELECT xet.event_id event_id
150430: , 0 line_number
150431: , CASE r
150432: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150430: , 0 line_number
150431: , CASE r
150432: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150431: , CASE r
150432: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150432: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150433: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150434: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150435: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150436: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150437: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150438: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150439: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150440: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150441: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150442: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150443: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150444: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150445: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150446: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150447: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150448: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150449: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150450: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150458: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150451: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150458: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150459:
150452: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150458: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150459:
150460: ELSE null
150453: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150458: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150459:
150460: ELSE null
150461: END object_name
150454: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150455: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150456: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150457: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150458: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
150459:
150460: ELSE null
150461: END object_name
150462: , CASE r
150591:
150592: ELSE null
150593: END source_meaning
150594: FROM xla_events_gt xet
150595: , AP_PAYMENT_EXTRACT_HEADER_V h2
150596: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
150597: , fnd_lookup_values fvl15
150598: , fnd_lookup_values fvl47
150599: , fnd_lookup_values fvl113
150991: --
150992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150993: --
150994:
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
150992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150993: --
150994:
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
150993: --
150994:
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
150994:
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
150995: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
150996: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
150997: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
150998: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
150999: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151000: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
151001: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151002: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
151003: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
151004: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151005: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151006: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151007: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151008: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151009: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151010: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151011: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151012: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151013: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151014: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151022:
151015: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151022:
151023: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
151016: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151022:
151023: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
151024: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
151017: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
151018: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
151019: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
151020: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
151021: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
151022:
151023: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
151024: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
151025: TYPE t_array_source_51 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
151166: , h2.AC_EXCHANGE_RATE_TYPE source_119
151167: , h2.AC_DOC_CATEGORY_CODE source_170
151168: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
151169: FROM xla_events_gt xet
151170: , AP_PAYMENT_EXTRACT_HEADER_V h2
151171: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
151172: , fnd_lookup_values fvl15
151173: , fnd_lookup_values fvl47
151174: , fnd_lookup_values fvl113
156233: FROM (
156234: SELECT xet.event_id event_id
156235: , 0 line_number
156236: , CASE r
156237: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156234: SELECT xet.event_id event_id
156235: , 0 line_number
156236: , CASE r
156237: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156235: , 0 line_number
156236: , CASE r
156237: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156236: , CASE r
156237: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156237: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156238: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156239: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156240: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156241: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156242: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156243: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156244: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156245: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156246: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156247: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156248: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156249: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156250: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156251: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156252: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156253: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156254: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156255: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156256: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156257: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156258: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156259: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156260: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156261: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156262: WHEN 26 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156263: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156264: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156265: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156266: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156267: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156275: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156268: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156275: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156276:
156269: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156275: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156276:
156277: ELSE null
156270: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156275: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156276:
156277: ELSE null
156278: END object_name
156271: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156272: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156273: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156274: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156275: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
156276:
156277: ELSE null
156278: END object_name
156279: , CASE r
156460:
156461: ELSE null
156462: END source_meaning
156463: FROM xla_events_gt xet
156464: , AP_PAYMENT_EXTRACT_HEADER_V h2
156465: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
156466: , fnd_lookup_values fvl15
156467: , fnd_lookup_values fvl19
156468: , fnd_lookup_values fvl25
156938: --
156939: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156940: --
156941:
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156939: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156940: --
156941:
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156940: --
156941:
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156941:
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156942: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156943: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
156944: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156945: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
156946: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
156947: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156948: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
156949: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
156950: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156951: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
156952: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
156953: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156954: TYPE t_array_source_26 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156955: TYPE t_array_source_27 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
156956: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156957: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
156958: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
156959: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156960: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
156961: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156962: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
156963: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156964: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156965: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156966: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156967: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156968: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156969: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156970: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156971: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156972: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156980: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
156973: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156980: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
156981:
156974: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156980: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
156981:
156982: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
156975: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156980: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
156981:
156982: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
156983: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
156976: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
156977: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
156978: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
156979: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
156980: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
156981:
156982: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
156983: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
156984: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
157177: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
157178: , h2.TRANSAC_REVERSAL_FLAG source_172
157179: , fvl172.meaning source_172_meaning
157180: FROM xla_events_gt xet
157181: , AP_PAYMENT_EXTRACT_HEADER_V h2
157182: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
157183: , fnd_lookup_values fvl15
157184: , fnd_lookup_values fvl19
157185: , fnd_lookup_values fvl25
164959: FROM (
164960: SELECT xet.event_id event_id
164961: , 0 line_number
164962: , CASE r
164963: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164960: SELECT xet.event_id event_id
164961: , 0 line_number
164962: , CASE r
164963: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164961: , 0 line_number
164962: , CASE r
164963: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164962: , CASE r
164963: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164963: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164964: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164965: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164966: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164967: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164968: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164969: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164970: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164971: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164972: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164973: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164974: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164975: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164976: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164977: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164978: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164979: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164980: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164981: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164982: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164983: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164984: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164985: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164986: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164987: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164988: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164989: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164990: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164991: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164992: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165000: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164993: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165000: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165001:
164994: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165000: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165001:
165002: ELSE null
164995: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165000: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165001:
165002: ELSE null
165003: END object_name
164996: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164997: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164998: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
164999: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165000: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
165001:
165002: ELSE null
165003: END object_name
165004: , CASE r
165179:
165180: ELSE null
165181: END source_meaning
165182: FROM xla_events_gt xet
165183: , AP_PAYMENT_EXTRACT_HEADER_V h2
165184: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165185: , fnd_lookup_values fvl15
165186: , fnd_lookup_values fvl19
165187: , fnd_lookup_values fvl47
165686: --
165687: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165688: --
165689:
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165687: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165688: --
165689:
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165688: --
165689:
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165689:
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165690: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165691: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165692: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
165693: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165694: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165695: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165696: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
165697: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
165698: TYPE t_array_source_16 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
165699: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165700: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165701: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165702: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
165703: TYPE t_array_source_29 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
165704: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165705: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
165706: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165707: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
165708: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165709: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165710: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165711: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165712: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165713: TYPE t_array_source_104 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165714: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165715: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165716: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165717: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165718: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165719: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165727: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165720: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165727: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165728:
165721: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165727: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165728:
165729: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165722: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165727: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165728:
165729: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165730: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165723: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
165724: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
165725: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
165726: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
165727: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
165728:
165729: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
165730: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
165731: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165934: , fvl122.meaning source_122_meaning
165935: , h2.AC_DOC_CATEGORY_CODE source_170
165936: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
165937: FROM xla_events_gt xet
165938: , AP_PAYMENT_EXTRACT_HEADER_V h2
165939: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
165940: , fnd_lookup_values fvl15
165941: , fnd_lookup_values fvl19
165942: , fnd_lookup_values fvl47
168083: FROM (
168084: SELECT xet.event_id event_id
168085: , 0 line_number
168086: , CASE r
168087: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168084: SELECT xet.event_id event_id
168085: , 0 line_number
168086: , CASE r
168087: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168085: , 0 line_number
168086: , CASE r
168087: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168086: , CASE r
168087: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168087: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168088: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168089: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168090: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168091: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168092: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168093: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168094: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168095: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168096: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168097: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168098: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168099: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168100: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168101: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168102: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168103: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168104: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168105: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168106: WHEN 20 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168107: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168108: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168109: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168110: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168118: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168111: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168118: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168119:
168112: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168118: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168119:
168120: ELSE null
168113: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168118: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168119:
168120: ELSE null
168121: END object_name
168114: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168115: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168116: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168117: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168118: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
168119:
168120: ELSE null
168121: END object_name
168122: , CASE r
168274:
168275: ELSE null
168276: END source_meaning
168277: FROM xla_events_gt xet
168278: , AP_PAYMENT_EXTRACT_HEADER_V h2
168279: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168280: , fnd_lookup_values fvl15
168281: , fnd_lookup_values fvl19
168282: , fnd_lookup_values fvl47
168694: --
168695: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168696: --
168697:
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168695: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168696: --
168697:
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168696: --
168697:
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168697:
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168698: TYPE t_array_source_6 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168699: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
168700: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168701: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
168702: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
168703: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168704: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168705: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
168706: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168707: TYPE t_array_source_19 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
168708: TYPE t_array_source_35 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
168709: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168710: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
168711: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168712: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
168713: TYPE t_array_source_44 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168714: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168715: TYPE t_array_source_48 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168716: TYPE t_array_source_82 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168717: TYPE t_array_source_96 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168718: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168719: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168720: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168721: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168729: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
168722: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168729: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
168730:
168723: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168729: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
168730:
168731: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
168724: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168729: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
168730:
168731: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
168732: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
168725: TYPE t_array_source_119 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
168726: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
168727: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
168728: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
168729: TYPE t_array_source_172 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
168730:
168731: TYPE t_array_source_30 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
168732: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
168733: TYPE t_array_source_45 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;
168893: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_171
168894: , h2.TRANSAC_REVERSAL_FLAG source_172
168895: , fvl172.meaning source_172_meaning
168896: FROM xla_events_gt xet
168897: , AP_PAYMENT_EXTRACT_HEADER_V h2
168898: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
168899: , fnd_lookup_values fvl15
168900: , fnd_lookup_values fvl19
168901: , fnd_lookup_values fvl47