[Home] [Help]
124323: FROM (
124324: SELECT xet.event_id event_id
124325: , l1.line_number line_number
124326: , CASE r
124327: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124324: SELECT xet.event_id event_id
124325: , l1.line_number line_number
124326: , CASE r
124327: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124325: , l1.line_number line_number
124326: , CASE r
124327: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124326: , CASE r
124327: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124327: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124328: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124329: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124330: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124331: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124332: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124333: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124334: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124335: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124343: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124336: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124343: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124344:
124337: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124343: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124344:
124345: ELSE null
124338: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124343: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124344:
124345: ELSE null
124346: END object_name
124339: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124340: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124341: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124342: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124343: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
124344:
124345: ELSE null
124346: END object_name
124347: , CASE r
124430: ELSE null
124431: END source_value
124432: , null source_meaning
124433: FROM xla_events_gt xet
124434: , PA_XLA_BC_PKT_AP_DETAIL_V l1
124435: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
124436: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
124437: AND xet.event_class_code = C_EVENT_CLASS_CODE
124438: AND l1.event_id = xet.event_id
124569: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
124570: --
124571:
124572:
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124570: --
124571:
124572:
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124571:
124572:
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124572:
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124573: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124574: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124575: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124576: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124577: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124578: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124579: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124580: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124581: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124589: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124582: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124589: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124590:
124583: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124589: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124590:
124591:
124584: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124589: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124590:
124591:
124592: l_array_source_48 t_array_source_48;
124585: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124586: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
124587: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
124588: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124589: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
124590:
124591:
124592: l_array_source_48 t_array_source_48;
124593: l_array_source_80 t_array_source_80;
124691: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
124692: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
124693: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
124694: FROM xla_events_gt xet
124695: , PA_XLA_BC_PKT_AP_DETAIL_V l1
124696: WHERE xet.event_id between x_first_event_id and x_last_event_id
124697: and xet.event_date between p_pad_start_date and p_pad_end_date
124698: and xet.event_class_code = C_EVENT_CLASS_CODE
124699: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
134978: FROM (
134979: SELECT xet.event_id event_id
134980: , l1.line_number line_number
134981: , CASE r
134982: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134979: SELECT xet.event_id event_id
134980: , l1.line_number line_number
134981: , CASE r
134982: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134980: , l1.line_number line_number
134981: , CASE r
134982: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134981: , CASE r
134982: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134982: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134983: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134984: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134985: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134986: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134987: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134988: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134989: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134990: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134998: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134991: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134998: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134999:
134992: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134998: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134999:
135000: ELSE null
134993: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134998: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134999:
135000: ELSE null
135001: END object_name
134994: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134995: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134996: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134997: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134998: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
134999:
135000: ELSE null
135001: END object_name
135002: , CASE r
135085: ELSE null
135086: END source_value
135087: , null source_meaning
135088: FROM xla_events_gt xet
135089: , PA_XLA_BC_PKT_AP_DETAIL_V l1
135090: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
135091: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
135092: AND xet.event_class_code = C_EVENT_CLASS_CODE
135093: AND l1.event_id = xet.event_id
135224: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
135225: --
135226:
135227:
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135225: --
135226:
135227:
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135226:
135227:
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135227:
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135228: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135229: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135230: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135231: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135232: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135233: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135234: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135235: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135236: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135244: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135237: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135244: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135245:
135238: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135244: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135245:
135246:
135239: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135244: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135245:
135246:
135247: l_array_source_48 t_array_source_48;
135240: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135241: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
135242: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
135243: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135244: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
135245:
135246:
135247: l_array_source_48 t_array_source_48;
135248: l_array_source_80 t_array_source_80;
135346: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
135347: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
135348: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
135349: FROM xla_events_gt xet
135350: , PA_XLA_BC_PKT_AP_DETAIL_V l1
135351: WHERE xet.event_id between x_first_event_id and x_last_event_id
135352: and xet.event_date between p_pad_start_date and p_pad_end_date
135353: and xet.event_class_code = C_EVENT_CLASS_CODE
135354: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id
136090: FROM (
136091: SELECT xet.event_id event_id
136092: , l1.line_number line_number
136093: , CASE r
136094: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136091: SELECT xet.event_id event_id
136092: , l1.line_number line_number
136093: , CASE r
136094: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136092: , l1.line_number line_number
136093: , CASE r
136094: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136093: , CASE r
136094: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136094: WHEN 1 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136095: WHEN 2 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136096: WHEN 3 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136097: WHEN 4 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136098: WHEN 5 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136099: WHEN 6 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136100: WHEN 7 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136101: WHEN 8 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136102: WHEN 9 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136110: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136103: WHEN 10 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136110: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136111:
136104: WHEN 11 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136110: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136111:
136112: ELSE null
136105: WHEN 12 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136110: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136111:
136112: ELSE null
136113: END object_name
136106: WHEN 13 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136107: WHEN 14 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136108: WHEN 15 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136109: WHEN 16 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136110: WHEN 17 THEN 'PA_XLA_BC_PKT_AP_DETAIL_V'
136111:
136112: ELSE null
136113: END object_name
136114: , CASE r
136197: ELSE null
136198: END source_value
136199: , null source_meaning
136200: FROM xla_events_gt xet
136201: , PA_XLA_BC_PKT_AP_DETAIL_V l1
136202: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
136203: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
136204: AND xet.event_class_code = C_EVENT_CLASS_CODE
136205: AND l1.event_id = xet.event_id
136336: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
136337: --
136338:
136339:
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136337: --
136338:
136339:
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136338:
136339:
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136339:
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136340: TYPE t_array_source_48 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136341: TYPE t_array_source_80 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AI_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136342: TYPE t_array_source_156 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_INVOICE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136343: TYPE t_array_source_161 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136344: TYPE t_array_source_162 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_EXPENDITURE_TYPE%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136345: TYPE t_array_source_163 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136346: TYPE t_array_source_164 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136347: TYPE t_array_source_165 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136348: TYPE t_array_source_166 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AID_BASE_AMT_NO_ROUND%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136356: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136349: TYPE t_array_source_167 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136356: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136357:
136350: TYPE t_array_source_168 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136356: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136357:
136358:
136351: TYPE t_array_source_169 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136356: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136357:
136358:
136359: l_array_source_48 t_array_source_48;
136352: TYPE t_array_source_170 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REVERSAL_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136353: TYPE t_array_source_171 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.AP_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
136354: TYPE t_array_source_172 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ACCT_REV_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
136355: TYPE t_array_source_173 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136356: TYPE t_array_source_174 IS TABLE OF PA_XLA_BC_PKT_AP_DETAIL_V.ENC_UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
136357:
136358:
136359: l_array_source_48 t_array_source_48;
136360: l_array_source_80 t_array_source_80;
136458: , l1.ACCT_REV_DISTRIBUTION_TYPE source_172
136459: , l1.ENC_UPG_CR_ENC_TYPE_ID source_173
136460: , l1.ENC_UPG_DR_ENC_TYPE_ID source_174
136461: FROM xla_events_gt xet
136462: , PA_XLA_BC_PKT_AP_DETAIL_V l1
136463: WHERE xet.event_id between x_first_event_id and x_last_event_id
136464: and xet.event_date between p_pad_start_date and p_pad_end_date
136465: and xet.event_class_code = C_EVENT_CLASS_CODE
136466: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id