[Home] [Help]
197585: FROM (
197586: SELECT xet.event_id event_id
197587: , l1.line_number line_number
197588: , CASE r
197589: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197586: SELECT xet.event_id event_id
197587: , l1.line_number line_number
197588: , CASE r
197589: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197587: , l1.line_number line_number
197588: , CASE r
197589: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197588: , CASE r
197589: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197589: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197590: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197591: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197592: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197593: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197594: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197595: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197596: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197597: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197605: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197598: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197605: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197606:
197599: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197605: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197606:
197607: ELSE null
197600: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197605: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197606:
197607: ELSE null
197608: END object_name
197601: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197602: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197603: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197604: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197605: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
197606:
197607: ELSE null
197608: END object_name
197609: , CASE r
197692: ELSE null
197693: END source_value
197694: , null source_meaning
197695: FROM xla_events_gt xet
197696: , PA_XLA_BC_PKT_AP_DETAIL_V l1
197697: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
197698: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197699: AND xet.event_class_code = C_EVENT_CLASS_CODE
197700: AND l1.event_id = xet.event_id
197831: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197832: --
197833:
197834:
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197832: --
197833:
197834:
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197833:
197834:
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197834:
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197835: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197836: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197837: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197838: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197839: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197840: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197841: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197842: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197843: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197851: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197844: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197851: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197852:
197845: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197851: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197852:
197853:
197846: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197851: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197852:
197853:
197854: l_array_source_43 t_array_source_43;
197847: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197848: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
197849: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197850: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197851: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
197852:
197853:
197854: l_array_source_43 t_array_source_43;
197855: l_array_source_52 t_array_source_52;
197953: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
197954: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
197955: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
197956: FROM xla_events_gt xet
197957: , PA_XLA_BC_PKT_AP_DETAIL_V l1
197958: WHERE xet.event_id between x_first_event_id and x_last_event_id
197959: and xet.event_date between p_pad_start_date and p_pad_end_date
197960: and xet.event_class_code = C_EVENT_CLASS_CODE
197961: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
208489: FROM (
208490: SELECT xet.event_id event_id
208491: , l1.line_number line_number
208492: , CASE r
208493: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208490: SELECT xet.event_id event_id
208491: , l1.line_number line_number
208492: , CASE r
208493: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208491: , l1.line_number line_number
208492: , CASE r
208493: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208492: , CASE r
208493: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208493: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208494: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208495: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208496: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208497: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208498: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208499: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208500: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208501: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208509: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208502: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208509: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208510:
208503: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208509: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208510:
208511: ELSE null
208504: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208509: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208510:
208511: ELSE null
208512: END object_name
208505: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208506: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208507: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208508: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208509: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
208510:
208511: ELSE null
208512: END object_name
208513: , CASE r
208596: ELSE null
208597: END source_value
208598: , null source_meaning
208599: FROM xla_events_gt xet
208600: , PA_XLA_BC_PKT_AP_DETAIL_V l1
208601: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
208602: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
208603: AND xet.event_class_code = C_EVENT_CLASS_CODE
208604: AND l1.event_id = xet.event_id
208735: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
208736: --
208737:
208738:
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208736: --
208737:
208738:
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208737:
208738:
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208738:
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208739: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208740: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208741: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208742: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208743: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208744: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208745: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208746: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208747: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208755: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208748: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208755: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208756:
208749: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208755: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208756:
208757:
208750: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208755: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208756:
208757:
208758: l_array_source_43 t_array_source_43;
208751: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208752: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
208753: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
208754: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208755: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
208756:
208757:
208758: l_array_source_43 t_array_source_43;
208759: l_array_source_52 t_array_source_52;
208857: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
208858: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
208859: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
208860: FROM xla_events_gt xet
208861: , PA_XLA_BC_PKT_AP_DETAIL_V l1
208862: WHERE xet.event_id between x_first_event_id and x_last_event_id
208863: and xet.event_date between p_pad_start_date and p_pad_end_date
208864: and xet.event_class_code = C_EVENT_CLASS_CODE
208865: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
209601: FROM (
209602: SELECT xet.event_id event_id
209603: , l1.line_number line_number
209604: , CASE r
209605: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209602: SELECT xet.event_id event_id
209603: , l1.line_number line_number
209604: , CASE r
209605: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209603: , l1.line_number line_number
209604: , CASE r
209605: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209604: , CASE r
209605: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209605: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209606: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209607: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209608: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209609: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209610: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209611: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209612: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209613: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209621: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209614: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209621: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209622:
209615: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209621: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209622:
209623: ELSE null
209616: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209621: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209622:
209623: ELSE null
209624: END object_name
209617: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209618: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209619: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209620: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209621: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
209622:
209623: ELSE null
209624: END object_name
209625: , CASE r
209708: ELSE null
209709: END source_value
209710: , null source_meaning
209711: FROM xla_events_gt xet
209712: , PA_XLA_BC_PKT_AP_DETAIL_V l1
209713: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
209714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
209715: AND xet.event_class_code = C_EVENT_CLASS_CODE
209716: AND l1.event_id = xet.event_id
209847: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
209848: --
209849:
209850:
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209848: --
209849:
209850:
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209849:
209850:
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209850:
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209851: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209852: TYPE t_array_source_52 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209853: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209854: TYPE t_array_source_61 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209855: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209856: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209857: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209858: TYPE t_array_source_175 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209859: TYPE t_array_source_176 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209867: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209860: TYPE t_array_source_177 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209867: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209868:
209861: TYPE t_array_source_178 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209867: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209868:
209869:
209862: TYPE t_array_source_179 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209867: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209868:
209869:
209870: l_array_source_43 t_array_source_43;
209863: TYPE t_array_source_180 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209864: TYPE t_array_source_181 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
209865: TYPE t_array_source_182 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
209866: TYPE t_array_source_183 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209867: TYPE t_array_source_184 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
209868:
209869:
209870: l_array_source_43 t_array_source_43;
209871: l_array_source_52 t_array_source_52;
209969: , l1.ACCT_REV_DISTRIBUTION_TYPE source_182
209970: , l1.ENC_UPG_CR_ENC_TYPE_ID source_183
209971: , l1.ENC_UPG_DR_ENC_TYPE_ID source_184
209972: FROM xla_events_gt xet
209973: , PA_XLA_BC_PKT_AP_DETAIL_V l1
209974: WHERE xet.event_id between x_first_event_id and x_last_event_id
209975: and xet.event_date between p_pad_start_date and p_pad_end_date
209976: and xet.event_class_code = C_EVENT_CLASS_CODE
209977: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id