DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000010_PKG dependencies on AP_PAYMENT_EXTRACT_HEADER_V

Line 121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121076: FROM (
121077: SELECT xet.event_id event_id
121078: , 0 line_number
121079: , CASE r
121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121078: , 0 line_number
121079: , CASE r
121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121080: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121081: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121082: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121083: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121084: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121085: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121086: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121087: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121088: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121089: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121090: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121091: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121092: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121093: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121094: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121102:

Line 121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121095: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121102:
121103: ELSE null

Line 121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121096: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121102:
121103: ELSE null
121104: END object_name

Line 121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

121097: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121098: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121099: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121100: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121101: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
121102:
121103: ELSE null
121104: END object_name
121105: , CASE r

Line 121218: , AP_PAYMENT_EXTRACT_HEADER_V h2

121214:
121215: ELSE null
121216: END source_meaning
121217: FROM xla_events_gt xet
121218: , AP_PAYMENT_EXTRACT_HEADER_V h2
121219: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121220: , fnd_lookup_values fvl4
121221: , fnd_lookup_values fvl30
121222: , fnd_lookup_values fvl110

Line 121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

121561: --
121562: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
121563: --
121564:
121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

121563: --
121564:
121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

121565: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
121566: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

121567: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
121568: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
121569: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121570: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

121571: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

121572: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

121573: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

121574: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

121575: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

121576: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

121577: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

121578: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

121579: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
121587:

Line 121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

121580: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
121587:
121588: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

121581: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
121587:
121588: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
121589: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

121582: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
121583: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
121584: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
121585: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
121586: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
121587:
121588: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
121589: TYPE t_array_source_17 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
121590: TYPE t_array_source_39 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAY_DIST_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 121707: , AP_PAYMENT_EXTRACT_HEADER_V h2

121703: , h2.AC_DOC_CATEGORY_CODE source_158
121704: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
121705: , h2.AC_DOC_SEQUENCE_VALUE source_160
121706: FROM xla_events_gt xet
121707: , AP_PAYMENT_EXTRACT_HEADER_V h2
121708: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
121709: , fnd_lookup_values fvl4
121710: , fnd_lookup_values fvl30
121711: , fnd_lookup_values fvl110

Line 125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125434: FROM (
125435: SELECT xet.event_id event_id
125436: , 0 line_number
125437: , CASE r
125438: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125439: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125440: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125441: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125442: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125443: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125444: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125445: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125446: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125447: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125448: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125449: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125450: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125451: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125452: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125453: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125454: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125455: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125456: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125457: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125458: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125459: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125460: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125461: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125462: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125463: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125464: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125465: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125473:

Line 125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125466: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125473:
125474: ELSE null

Line 125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125467: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125473:
125474: ELSE null
125475: END object_name

Line 125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

125468: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125469: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125470: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125471: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125472: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
125473:
125474: ELSE null
125475: END object_name
125476: , CASE r

Line 125647: , AP_PAYMENT_EXTRACT_HEADER_V h2

125643:
125644: ELSE null
125645: END source_meaning
125646: FROM xla_events_gt xet
125647: , AP_PAYMENT_EXTRACT_HEADER_V h2
125648: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
125649: , fnd_lookup_values fvl3
125650: , fnd_lookup_values fvl4
125651: , fnd_lookup_values fvl12

Line 126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

126158: --
126159: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
126160: --
126161:
126162: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
126163: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

126164: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
126165: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
126166: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

126167: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
126168: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
126169: TYPE t_array_source_12 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
126170: TYPE t_array_source_13 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

126171: TYPE t_array_source_14 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
126172: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
126173: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
126174: TYPE t_array_source_18 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

126175: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
126176: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

126177: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

126178: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

126179: TYPE t_array_source_31 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

126180: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

126181: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
126182: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

126183: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

126184: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

126185: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

126186: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

126187: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

126188: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

126189: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
126197:

Line 126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

126190: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
126197:
126198: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

126191: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
126197:
126198: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
126199: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

126192: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
126193: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
126194: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
126195: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
126196: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
126197:
126198: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
126199: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
126200: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 126402: , AP_PAYMENT_EXTRACT_HEADER_V h2

126398: , h2.AC_DOC_SEQUENCE_VALUE source_160
126399: , h2.TRANSAC_REVERSAL_FLAG source_175
126400: , fvl175.meaning source_175_meaning
126401: FROM xla_events_gt xet
126402: , AP_PAYMENT_EXTRACT_HEADER_V h2
126403: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
126404: , fnd_lookup_values fvl3
126405: , fnd_lookup_values fvl4
126406: , fnd_lookup_values fvl12

Line 137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137201: FROM (
137202: SELECT xet.event_id event_id
137203: , 0 line_number
137204: , CASE r
137205: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137206: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137207: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137208: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137209: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137210: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137211: WHEN 7 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137212: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137213: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137214: WHEN 10 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137215: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137216: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137217: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137218: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137219: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137220: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137221: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137222: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137223: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137224: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137225: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137226: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137227: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137228: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137229: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137230: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137231: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137232: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137233: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137234: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137242:

Line 137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137235: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137242:
137243: ELSE null

Line 137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137236: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137242:
137243: ELSE null
137244: END object_name

Line 137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

137237: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137238: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137239: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137240: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137241: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
137242:
137243: ELSE null
137244: END object_name
137245: , CASE r

Line 137421: , AP_PAYMENT_EXTRACT_HEADER_V h2

137417:
137418: ELSE null
137419: END source_meaning
137420: FROM xla_events_gt xet
137421: , AP_PAYMENT_EXTRACT_HEADER_V h2
137422: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
137423: , fnd_lookup_values fvl3
137424: , fnd_lookup_values fvl4
137425: , fnd_lookup_values fvl30

Line 137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

137962: --
137963: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
137964: --
137965:
137966: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
137967: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137968: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
137969: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
137970: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

137971: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;

137972: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
137973: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
137974: TYPE t_array_source_22 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

137975: TYPE t_array_source_25 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
137976: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

137977: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
137978: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
137979: TYPE t_array_source_32 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137980: TYPE t_array_source_33 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

137981: TYPE t_array_source_34 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

137982: TYPE t_array_source_35 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

137983: TYPE t_array_source_37 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

137984: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

137985: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137986: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

Line 137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

137987: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

137988: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

137989: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

137990: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

137991: TYPE t_array_source_106 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

137992: TYPE t_array_source_107 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

137993: TYPE t_array_source_108 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

137994: TYPE t_array_source_109 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

137995: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
138003:

Line 138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

137996: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
138003:
138004: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

137997: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
138003:
138004: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
138005: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

137998: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
137999: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
138000: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
138001: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
138002: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
138003:
138004: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
138005: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
138006: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 138223: , AP_PAYMENT_EXTRACT_HEADER_V h2

138219: , h2.AC_DOC_CATEGORY_CODE source_158
138220: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_159
138221: , h2.AC_DOC_SEQUENCE_VALUE source_160
138222: FROM xla_events_gt xet
138223: , AP_PAYMENT_EXTRACT_HEADER_V h2
138224: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
138225: , fnd_lookup_values fvl3
138226: , fnd_lookup_values fvl4
138227: , fnd_lookup_values fvl30

Line 141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141408: FROM (
141409: SELECT xet.event_id event_id
141410: , 0 line_number
141411: , CASE r
141412: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141413: WHEN 2 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141414: WHEN 3 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141415: WHEN 4 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141416: WHEN 5 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141417: WHEN 6 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141418: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141419: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141420: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141421: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141422: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141423: WHEN 12 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141424: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141425: WHEN 14 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141426: WHEN 15 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141427: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141428: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141429: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141437:

Line 141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141430: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141437:
141438: ELSE null

Line 141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141431: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141437:
141438: ELSE null
141439: END object_name

Line 141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

141432: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141433: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141434: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141435: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141436: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
141437:
141438: ELSE null
141439: END object_name
141440: , CASE r

Line 141569: , AP_PAYMENT_EXTRACT_HEADER_V h2

141565:
141566: ELSE null
141567: END source_meaning
141568: FROM xla_events_gt xet
141569: , AP_PAYMENT_EXTRACT_HEADER_V h2
141570: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
141571: , fnd_lookup_values fvl3
141572: , fnd_lookup_values fvl4
141573: , fnd_lookup_values fvl30

Line 142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

142020: --
142021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142022: --
142023:
142024: TYPE t_array_source_1 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
142025: TYPE t_array_source_2 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

142026: TYPE t_array_source_3 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
142027: TYPE t_array_source_4 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
142028: TYPE t_array_source_5 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
142029: TYPE t_array_source_8 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

142030: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

142031: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

142032: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

142033: TYPE t_array_source_38 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

142034: TYPE t_array_source_49 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
142035: TYPE t_array_source_54 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

142036: TYPE t_array_source_55 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

142037: TYPE t_array_source_56 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

142038: TYPE t_array_source_60 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

142039: TYPE t_array_source_102 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

142040: TYPE t_array_source_110 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

142041: TYPE t_array_source_111 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
142049:

Line 142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

142042: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
142049:
142050: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

142043: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
142049:
142050: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
142051: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

142044: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
142045: TYPE t_array_source_158 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
142046: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
142047: TYPE t_array_source_160 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
142048: TYPE t_array_source_175 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
142049:
142050: TYPE t_array_source_7 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
142051: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
142052: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 142210: , AP_PAYMENT_EXTRACT_HEADER_V h2

142206: , h2.AC_DOC_SEQUENCE_VALUE source_160
142207: , h2.TRANSAC_REVERSAL_FLAG source_175
142208: , fvl175.meaning source_175_meaning
142209: FROM xla_events_gt xet
142210: , AP_PAYMENT_EXTRACT_HEADER_V h2
142211: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
142212: , fnd_lookup_values fvl3
142213: , fnd_lookup_values fvl4
142214: , fnd_lookup_values fvl30