DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000011_PKG dependencies on AP_PAYMENT_EXTRACT_HEADER_V

Line 96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96631: FROM (
96632: SELECT xet.event_id event_id
96633: , 0 line_number
96634: , CASE r
96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96632: SELECT xet.event_id event_id
96633: , 0 line_number
96634: , CASE r
96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96633: , 0 line_number
96634: , CASE r
96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96634: , CASE r
96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96635: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96636: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96637: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96638: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96639: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96640: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96641: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96642: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96643: WHEN 9 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96644: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96645: WHEN 11 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96646: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96647: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96648: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96649: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96650: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96651: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96652: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96653: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96661:

Line 96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96654: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96661:
96662: ELSE null

Line 96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96655: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96661:
96662: ELSE null
96663: END object_name

Line 96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

96656: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96657: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96658: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96659: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96660: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
96661:
96662: ELSE null
96663: END object_name
96664: , CASE r

Line 96793: , AP_PAYMENT_EXTRACT_HEADER_V h2

96789:
96790: ELSE null
96791: END source_meaning
96792: FROM xla_events_gt xet
96793: , AP_PAYMENT_EXTRACT_HEADER_V h2
96794: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
96795: , fnd_lookup_values fvl16
96796: , fnd_lookup_values fvl42
96797: , fnd_lookup_values fvl117

Line 97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

97136: --
97137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
97138: --
97139:
97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

97137: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
97138: --
97139:
97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

97138: --
97139:
97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;

97139:
97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

97140: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

97141: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

97142: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
97143: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

97144: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
97145: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

97146: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
97147: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

97148: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
97149: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
97150: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97151: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

97152: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

97153: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

97154: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

97155: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

97156: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

97157: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

97158: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
97166:

Line 97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

97159: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
97166:
97167: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

97160: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
97166:
97167: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
97168: TYPE t_array_source_29 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

97161: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
97162: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
97163: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
97164: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
97165: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
97166:
97167: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
97168: TYPE t_array_source_29 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.AID_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
97169: TYPE t_array_source_51 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAY_DIST_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 97294: , AP_PAYMENT_EXTRACT_HEADER_V h2

97290: , h2.AC_EXCHANGE_RATE_TYPE source_123
97291: , h2.AC_DOC_CATEGORY_CODE source_156
97292: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
97293: FROM xla_events_gt xet
97294: , AP_PAYMENT_EXTRACT_HEADER_V h2
97295: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
97296: , fnd_lookup_values fvl16
97297: , fnd_lookup_values fvl42
97298: , fnd_lookup_values fvl117

Line 98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98674: FROM (
98675: SELECT xet.event_id event_id
98676: , 0 line_number
98677: , CASE r
98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98675: SELECT xet.event_id event_id
98676: , 0 line_number
98677: , CASE r
98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98676: , 0 line_number
98677: , CASE r
98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98677: , CASE r
98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98678: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98679: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98680: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98681: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98682: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98683: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98684: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98685: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98686: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98687: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98688: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98689: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98690: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98691: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98692: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98693: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98694: WHEN 17 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98695: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98696: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98697: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98698: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98699: WHEN 22 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98700: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98701: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98702: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98703: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98704: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98705: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98706: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98707: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98708: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98716:

Line 98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98709: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98716:
98717: ELSE null

Line 98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98710: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98716:
98717: ELSE null
98718: END object_name

Line 98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

98711: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98712: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98713: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98714: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98715: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
98716:
98717: ELSE null
98718: END object_name
98719: , CASE r

Line 98901: , AP_PAYMENT_EXTRACT_HEADER_V h2

98897:
98898: ELSE null
98899: END source_meaning
98900: FROM xla_events_gt xet
98901: , AP_PAYMENT_EXTRACT_HEADER_V h2
98902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
98903: , fnd_lookup_values fvl15
98904: , fnd_lookup_values fvl16
98905: , fnd_lookup_values fvl24

Line 99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

99376: --
99377: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
99378: --
99379:
99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

99377: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
99378: --
99379:
99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

99378: --
99379:
99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;

99379:
99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

99380: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

Line 99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

99381: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

99382: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
99383: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
99384: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
99385: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
99386: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
99387: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;

99388: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
99389: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
99390: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;

99391: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
99392: TYPE t_array_source_23 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_FUTURE_DATED_PMT_CCID%TYPE INDEX BY BINARY_INTEGER;
99393: TYPE t_array_source_24 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_FD_PMT_ACCT_SOURCE%TYPE INDEX BY BINARY_INTEGER;
99394: TYPE t_array_source_25 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_FUTURE_DATED_PAYMENT_CCID%TYPE INDEX BY BINARY_INTEGER;
99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

99395: TYPE t_array_source_26 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.POS_FDP_CCID%TYPE INDEX BY BINARY_INTEGER;
99396: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
99397: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
99398: TYPE t_array_source_30 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_BUILD_PREPAY_ACCOUNTS_FLAG%TYPE INDEX BY BINARY_INTEGER;
99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;

99399: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
99400: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

99401: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

99402: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

99403: TYPE t_array_source_43 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYCARD_ACCRUED_ACCOUNT_CCID%TYPE INDEX BY BINARY_INTEGER;
99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

99404: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

99405: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

99406: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;

99407: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

99408: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

99409: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

99410: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
99418:

Line 99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

99411: TYPE t_array_source_120 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_PROCESSING_TYPE%TYPE INDEX BY BINARY_INTEGER;
99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
99418:
99419: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

99412: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
99418:
99419: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
99420: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

99413: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
99414: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
99415: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
99416: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
99417: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
99418:
99419: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
99420: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
99421: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 99616: , AP_PAYMENT_EXTRACT_HEADER_V h2

99612: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
99613: , h2.TRANSAC_REVERSAL_FLAG source_159
99614: , fvl159.meaning source_159_meaning
99615: FROM xla_events_gt xet
99616: , AP_PAYMENT_EXTRACT_HEADER_V h2
99617: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
99618: , fnd_lookup_values fvl15
99619: , fnd_lookup_values fvl16
99620: , fnd_lookup_values fvl24

Line 106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106235: FROM (
106236: SELECT xet.event_id event_id
106237: , 0 line_number
106238: , CASE r
106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106236: SELECT xet.event_id event_id
106237: , 0 line_number
106238: , CASE r
106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106237: , 0 line_number
106238: , CASE r
106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106238: , CASE r
106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106239: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106240: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106241: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106242: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106243: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106244: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106245: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106246: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106247: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106248: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106249: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106250: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106251: WHEN 13 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106252: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106253: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106254: WHEN 16 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106255: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106256: WHEN 18 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106257: WHEN 19 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106258: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106259: WHEN 21 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106260: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106261: WHEN 23 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106262: WHEN 24 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106263: WHEN 25 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106264: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106265: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106266: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106267: WHEN 29 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106268: WHEN 30 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106269: WHEN 31 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106270: WHEN 32 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106271: WHEN 33 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106279:

Line 106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106272: WHEN 34 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106279:
106280: ELSE null

Line 106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106273: WHEN 35 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106279:
106280: ELSE null
106281: END object_name

Line 106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

106274: WHEN 36 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106275: WHEN 37 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106276: WHEN 38 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106277: WHEN 39 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106278: WHEN 40 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
106279:
106280: ELSE null
106281: END object_name
106282: , CASE r

Line 106469: , AP_PAYMENT_EXTRACT_HEADER_V h2

106465:
106466: ELSE null
106467: END source_meaning
106468: FROM xla_events_gt xet
106469: , AP_PAYMENT_EXTRACT_HEADER_V h2
106470: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
106471: , fnd_lookup_values fvl15
106472: , fnd_lookup_values fvl16
106473: , fnd_lookup_values fvl42

Line 106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

106954: --
106955: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
106956: --
106957:
106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

106955: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
106956: --
106957:
106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

106956: --
106957:
106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;

106957:
106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

106958: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

Line 106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

106959: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

106960: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
106961: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
106962: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
106963: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106964: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
106965: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106966: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
106967: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
106968: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;

106969: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;

106970: TYPE t_array_source_27 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_INTEREST_CCID%TYPE INDEX BY BINARY_INTEGER;
106971: TYPE t_array_source_28 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_PRORATE_INT_ACROSS_DISTS%TYPE INDEX BY BINARY_INTEGER;
106972: TYPE t_array_source_34 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_RETAINAGE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

106973: TYPE t_array_source_37 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
106974: TYPE t_array_source_38 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_BANK_ERRORS_CCID%TYPE INDEX BY BINARY_INTEGER;
106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;

106975: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
106976: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
106977: TYPE t_array_source_44 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106978: TYPE t_array_source_45 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

106979: TYPE t_array_source_46 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

106980: TYPE t_array_source_47 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

106981: TYPE t_array_source_49 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_ROUNDING_ERROR_CCID%TYPE INDEX BY BINARY_INTEGER;
106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

Line 106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

106982: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

106983: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;

106984: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;

106985: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

106986: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

106987: TYPE t_array_source_113 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

106988: TYPE t_array_source_114 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_DATE%TYPE INDEX BY BINARY_INTEGER;
106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

106989: TYPE t_array_source_115 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE%TYPE INDEX BY BINARY_INTEGER;
106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

106990: TYPE t_array_source_116 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.APH_BANK_TO_BASE_XRATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
106998:

Line 106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

106991: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
106998:
106999: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

106992: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
106998:
106999: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
107000: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

106993: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
106994: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
106995: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
106996: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
106997: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
106998:
106999: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
107000: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
107001: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 107203: , AP_PAYMENT_EXTRACT_HEADER_V h2

107199: , h2.AC_EXCHANGE_RATE_TYPE source_123
107200: , h2.AC_DOC_CATEGORY_CODE source_156
107201: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
107202: FROM xla_events_gt xet
107203: , AP_PAYMENT_EXTRACT_HEADER_V h2
107204: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
107205: , fnd_lookup_values fvl15
107206: , fnd_lookup_values fvl16
107207: , fnd_lookup_values fvl42

Line 109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109798: FROM (
109799: SELECT xet.event_id event_id
109800: , 0 line_number
109801: , CASE r
109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109799: SELECT xet.event_id event_id
109800: , 0 line_number
109801: , CASE r
109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109800: , 0 line_number
109801: , CASE r
109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109801: , CASE r
109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109802: WHEN 1 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109803: WHEN 2 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109804: WHEN 3 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109805: WHEN 4 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109806: WHEN 5 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109807: WHEN 6 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109808: WHEN 7 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109809: WHEN 8 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'

Line 109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109810: WHEN 9 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109811: WHEN 10 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109812: WHEN 11 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109813: WHEN 12 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109814: WHEN 13 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109815: WHEN 14 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109816: WHEN 15 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109817: WHEN 16 THEN 'AP_SYSTEM_PARAMETERS_EXTRACT_V'
109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109818: WHEN 17 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109819: WHEN 18 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109820: WHEN 19 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109821: WHEN 20 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

Line 109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109822: WHEN 21 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109830:

Line 109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109823: WHEN 22 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109830:
109831: ELSE null

Line 109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109824: WHEN 23 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109830:
109831: ELSE null
109832: END object_name

Line 109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'

109825: WHEN 24 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109826: WHEN 25 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109827: WHEN 26 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109828: WHEN 27 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109829: WHEN 28 THEN 'AP_PAYMENT_EXTRACT_HEADER_V'
109830:
109831: ELSE null
109832: END object_name
109833: , CASE r

Line 109973: , AP_PAYMENT_EXTRACT_HEADER_V h2

109969:
109970: ELSE null
109971: END source_meaning
109972: FROM xla_events_gt xet
109973: , AP_PAYMENT_EXTRACT_HEADER_V h2
109974: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
109975: , fnd_lookup_values fvl15
109976: , fnd_lookup_values fvl16
109977: , fnd_lookup_values fvl42

Line 110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;

110397: --
110398: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
110399: --
110400:
110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

Line 110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;

110398: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
110399: --
110400:
110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

110399: --
110400:
110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;

110400:
110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;

110401: TYPE t_array_source_5 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.DOC_SEQUENCE_NAME%TYPE INDEX BY BINARY_INTEGER;
110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;

Line 110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

110402: TYPE t_array_source_8 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;

Line 110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;

110403: TYPE t_array_source_9 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
110404: TYPE t_array_source_10 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CHECK_DATE%TYPE INDEX BY BINARY_INTEGER;
110405: TYPE t_array_source_11 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_BANK_ACCOUNT_NAME%TYPE INDEX BY BINARY_INTEGER;
110406: TYPE t_array_source_12 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
110407: TYPE t_array_source_13 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_AP_ASSET_CCID%TYPE INDEX BY BINARY_INTEGER;
110408: TYPE t_array_source_14 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.FSP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;

110409: TYPE t_array_source_15 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISCOUNT_DIST_METHOD%TYPE INDEX BY BINARY_INTEGER;
110410: TYPE t_array_source_16 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTOMATIC_OFFSETS_VALUE%TYPE INDEX BY BINARY_INTEGER;
110411: TYPE t_array_source_17 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_GAIN_CCID%TYPE INDEX BY BINARY_INTEGER;
110412: TYPE t_array_source_20 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_RATE_VAR_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;

110413: TYPE t_array_source_33 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CGAC_CASH_CLEARING_CCID%TYPE INDEX BY BINARY_INTEGER;
110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

110414: TYPE t_array_source_39 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_DISC_TAKEN_CCID%TYPE INDEX BY BINARY_INTEGER;
110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;

110415: TYPE t_array_source_42 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_AUTO_OFFSET_FLAG%TYPE INDEX BY BINARY_INTEGER;
110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;

110416: TYPE t_array_source_50 IS TABLE OF AP_SYSTEM_PARAMETERS_EXTRACT_V.ASP_WHEN_TO_ACCOUNT_PMT%TYPE INDEX BY BINARY_INTEGER;
110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;

110417: TYPE t_array_source_65 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_ID%TYPE INDEX BY BINARY_INTEGER;
110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;

110418: TYPE t_array_source_66 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_VENDOR_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;

110419: TYPE t_array_source_67 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.THIRD_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

110420: TYPE t_array_source_71 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_TYPE%TYPE INDEX BY BINARY_INTEGER;
110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

110421: TYPE t_array_source_117 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.CBA_POOLED_BANK_ACOUNT_FLAG%TYPE INDEX BY BINARY_INTEGER;
110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
110429:

Line 110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;

110422: TYPE t_array_source_118 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_FUTURE_PAY_DUE_DATE%TYPE INDEX BY BINARY_INTEGER;
110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
110429:
110430: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

110423: TYPE t_array_source_121 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_DATE%TYPE INDEX BY BINARY_INTEGER;
110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
110429:
110430: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
110431: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

110424: TYPE t_array_source_122 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
110425: TYPE t_array_source_123 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
110426: TYPE t_array_source_156 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.AC_DOC_CATEGORY_CODE%TYPE INDEX BY BINARY_INTEGER;
110427: TYPE t_array_source_157 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.PAYMENT_DOCUMENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
110428: TYPE t_array_source_159 IS TABLE OF AP_PAYMENT_EXTRACT_HEADER_V.TRANSAC_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
110429:
110430: TYPE t_array_source_19 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.RELATED_INV_DIST_DEST_TYPE%TYPE INDEX BY BINARY_INTEGER;
110431: TYPE t_array_source_21 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_PAYMENT_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;
110432: TYPE t_array_source_22 IS TABLE OF AP_PAYMENT_EXTRACT_DETAILS_V.APHD_CLEARING_BASE_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 110588: , AP_PAYMENT_EXTRACT_HEADER_V h2

110584: , h2.PAYMENT_DOCUMENT_SEQUENCE_ID source_157
110585: , h2.TRANSAC_REVERSAL_FLAG source_159
110586: , fvl159.meaning source_159_meaning
110587: FROM xla_events_gt xet
110588: , AP_PAYMENT_EXTRACT_HEADER_V h2
110589: , AP_SYSTEM_PARAMETERS_EXTRACT_V h4
110590: , fnd_lookup_values fvl15
110591: , fnd_lookup_values fvl16
110592: , fnd_lookup_values fvl42