eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00200_AAD_S_000006_PKG dependencies on AP_PAYMENT_EXTRACT_HEADER_V

Line 190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190936: SELECT xet.event_id event_id
190937: , 0 line_number
190938: , CASE r
190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190937: , 0 line_number
190938: , CASE r
190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190938: , CASE r
190939: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190940: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190941: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190942: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190943: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190944: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190945: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190946: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190947: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190948: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190949: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190950: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190951: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190952: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190953: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190961:

Line 190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190954: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190961:
190962: ELSE null

Line 190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190955: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190961:
190962: ELSE null
190963: END object_name

Line 190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

190956: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190957: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190958: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190959: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190960: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
190961:
190962: ELSE null
190963: END object_name
190964: , CASE r

Line 191077: , AP_PAYMENT_EXTRACT_HEADER_V h2

191073:
191074: ELSE null
191075: END source_meaning
191076: FROM xla_events_gt xet
191077: , AP_PAYMENT_EXTRACT_HEADER_V h2
191078: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191079: , fnd_lookup_values fvl3
191080: , fnd_lookup_values fvl35
191081: , fnd_lookup_values fvl105

Line 191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

191474: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191475: --
191476:
191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

191475: --
191476:
191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

191476:
191477: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

191478: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
191479: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
191480: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191481: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

191482: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191483: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

191484: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

191485: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

191486: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

191487: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

191488: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

191489: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

191490: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

191491: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
191499:

Line 191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

191492: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
191499:
191500: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

191493: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
191499:
191500: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
191501: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

191494: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
191495: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
191496: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
191497: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
191498: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
191499:
191500: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
191501: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
191502: TYPE t_array_source_40 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 191637: , AP_PAYMENT_EXTRACT_HEADER_V h2

191633: , h2.AC_DOC_CATEGORY_CODE source_169
191634: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
191635: , h2.AC_DOC_SEQUENCE_VALUE source_171
191636: FROM xla_events_gt xet
191637: , AP_PAYMENT_EXTRACT_HEADER_V h2
191638: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
191639: , fnd_lookup_values fvl3
191640: , fnd_lookup_values fvl35
191641: , fnd_lookup_values fvl105

Line 198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198697: SELECT xet.event_id event_id
198698: , 0 line_number
198699: , CASE r
198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198700: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198701: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198702: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198703: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198704: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198705: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198706: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198707: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198708: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198709: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198710: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198711: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198712: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198713: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198714: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198715: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198716: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198717: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198718: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198719: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198720: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198721: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198722: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198723: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198724: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198725: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198726: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198727: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198735:

Line 198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198728: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198735:
198736: ELSE null

Line 198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198729: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198735:
198736: ELSE null
198737: END object_name

Line 198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

198730: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198731: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198732: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198733: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198734: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
198735:
198736: ELSE null
198737: END object_name
198738: , CASE r

Line 198907: , AP_PAYMENT_EXTRACT_HEADER_V h2

198903:
198904: ELSE null
198905: END source_meaning
198906: FROM xla_events_gt xet
198907: , AP_PAYMENT_EXTRACT_HEADER_V h2
198908: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
198909: , fnd_lookup_values fvl3
198910: , fnd_lookup_values fvl7
198911: , fnd_lookup_values fvl13

Line 199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

199382: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199383: --
199384:
199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;

Line 199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

199385: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
199386: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
199387: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

199388: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
199389: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
199390: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

199391: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

199392: TYPE t_array_source_15 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
199393: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

199394: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
199395: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
199396: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199397: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

199398: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199399: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

199400: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
199401: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

199402: TYPE t_array_source_36 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

199403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

199404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

199405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

199406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

199407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

199408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

199409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

199410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

199411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

199412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
199420:

Line 199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

199413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
199420:
199421: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

199414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
199420:
199421: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
199422: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

199415: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
199416: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
199417: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
199418: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
199419: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
199420:
199421: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
199422: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
199423: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 199612: , AP_PAYMENT_EXTRACT_HEADER_V h2

199608: , h2.AC_DOC_SEQUENCE_VALUE source_171
199609: , h2.TRANSAC_REVERSAL_FLAG source_185
199610: , fvl185.meaning source_185_meaning
199611: FROM xla_events_gt xet
199612: , AP_PAYMENT_EXTRACT_HEADER_V h2
199613: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
199614: , fnd_lookup_values fvl3
199615: , fnd_lookup_values fvl7
199616: , fnd_lookup_values fvl13

Line 210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210712: FROM (
210713: SELECT xet.event_id event_id
210714: , 0 line_number
210715: , CASE r
210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210714: , 0 line_number
210715: , CASE r
210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210715: , CASE r
210716: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210717: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210718: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210719: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210720: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210721: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210722: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210723: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210724: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210725: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210726: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210727: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210728: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210729: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210730: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210731: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210732: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210733: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210734: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210735: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210736: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210737: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210738: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210739: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210740: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210741: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210749:

Line 210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210742: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210749:
210750: ELSE null

Line 210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210743: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210749:
210750: ELSE null
210751: END object_name

Line 210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

210744: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210745: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210746: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210747: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210748: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
210749:
210750: ELSE null
210751: END object_name
210752: , CASE r

Line 210911: , AP_PAYMENT_EXTRACT_HEADER_V h2

210907:
210908: ELSE null
210909: END source_meaning
210910: FROM xla_events_gt xet
210911: , AP_PAYMENT_EXTRACT_HEADER_V h2
210912: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
210913: , fnd_lookup_values fvl3
210914: , fnd_lookup_values fvl7
210915: , fnd_lookup_values fvl35

Line 211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

211414: --
211415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
211416: --
211417:
211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;

211416: --
211417:
211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

211417:
211418: TYPE t_array_source_2 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
211419: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
211420: TYPE t_array_source_4 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
211421: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;

Line 211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

211422: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211423: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

211424: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
211425: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
211426: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211427: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
211428: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

211429: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
211430: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

Line 211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

211431: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

211432: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

211433: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

211434: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

211435: TYPE t_array_source_97 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

211436: TYPE t_array_source_98 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

211437: TYPE t_array_source_99 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

211438: TYPE t_array_source_100 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

211439: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

211440: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

211441: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

211442: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

211443: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
211451:

Line 211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

211444: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
211451:
211452: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

211445: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
211451:
211452: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
211453: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

211446: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
211447: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
211448: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
211449: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
211450: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
211451:
211452: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
211453: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
211454: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AWT_RELATED_DIST_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 211651: , AP_PAYMENT_EXTRACT_HEADER_V h2

211647: , h2.AC_DOC_CATEGORY_CODE source_169
211648: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_170
211649: , h2.AC_DOC_SEQUENCE_VALUE source_171
211650: FROM xla_events_gt xet
211651: , AP_PAYMENT_EXTRACT_HEADER_V h2
211652: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
211653: , fnd_lookup_values fvl3
211654: , fnd_lookup_values fvl7
211655: , fnd_lookup_values fvl35

Line 213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213803: SELECT xet.event_id event_id
213804: , 0 line_number
213805: , CASE r
213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213806: WHEN 1 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213807: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213808: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213809: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213810: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213811: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213812: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213813: WHEN 8 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213814: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213815: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213816: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213817: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213818: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213819: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213820: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213821: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213822: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213823: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213824: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213825: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213833:

Line 213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213826: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213833:
213834: ELSE null

Line 213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213827: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213833:
213834: ELSE null
213835: END object_name

Line 213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

213828: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213829: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213830: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213831: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213832: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
213833:
213834: ELSE null
213835: END object_name
213836: , CASE r

Line 213972: , AP_PAYMENT_EXTRACT_HEADER_V h2

213968:
213969: ELSE null
213970: END source_meaning
213971: FROM xla_events_gt xet
213972: , AP_PAYMENT_EXTRACT_HEADER_V h2
213973: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
213974: , fnd_lookup_values fvl3
213975: , fnd_lookup_values fvl7
213976: , fnd_lookup_values fvl35

Line 214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

214389: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
214390: --
214391:
214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

214392: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

214393: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
214394: TYPE t_array_source_6 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

214395: TYPE t_array_source_7 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
214396: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
214397: TYPE t_array_source_24 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214398: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
214399: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

214400: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
214401: TYPE t_array_source_32 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

214402: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

214403: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

214404: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

214405: TYPE t_array_source_89 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

214406: TYPE t_array_source_102 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

214407: TYPE t_array_source_103 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

214408: TYPE t_array_source_105 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

214409: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

214410: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

214411: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
214419:

Line 214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

214412: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
214419:
214420: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

214413: TYPE t_array_source_112 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
214419:
214420: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
214421: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

214414: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
214415: TYPE t_array_source_169 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
214416: TYPE t_array_source_170 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
214417: TYPE t_array_source_171 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
214418: TYPE t_array_source_185 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
214419:
214420: TYPE t_array_source_18 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
214421: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_LINE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
214422: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.POD_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 214576: , AP_PAYMENT_EXTRACT_HEADER_V h2

214572: , h2.AC_DOC_SEQUENCE_VALUE source_171
214573: , h2.TRANSAC_REVERSAL_FLAG source_185
214574: , fvl185.meaning source_185_meaning
214575: FROM xla_events_gt xet
214576: , AP_PAYMENT_EXTRACT_HEADER_V h2
214577: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
214578: , fnd_lookup_values fvl3
214579: , fnd_lookup_values fvl7
214580: , fnd_lookup_values fvl35