74150: FROM (
74151: SELECT xet.event_id event_id
74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74151: SELECT xet.event_id event_id
74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null
74174: END object_name
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null
74174: END object_name
74175: , CASE r
74272:
74273: ELSE null
74274: END source_meaning
74275: FROM xla_events_gt xet
74276: , PA_XLA_CCDL_LINES_V l1
74277: , fnd_lookup_values fvl35
74278: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
74279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74280: AND xet.event_class_code = C_EVENT_CLASS_CODE
74417: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;
74441: l_array_source_73 t_array_source_73;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;
74441: l_array_source_73 t_array_source_73;
74442: l_array_source_73_meaning t_array_lookup_meaning;
74559: , l1.LINE_NUM_REVERSED source_36
74560: , l1.ENTERED_AMOUNT source_42
74561: , l1.ACCT_AMOUNT source_43
74562: FROM xla_events_gt xet
74563: , PA_XLA_CCDL_LINES_V l1
74564: , fnd_lookup_values fvl35
74565: WHERE xet.event_id between x_first_event_id and x_last_event_id
74566: and xet.event_date between p_pad_start_date and p_pad_end_date
74567: and xet.event_class_code = C_EVENT_CLASS_CODE
75558: FROM (
75559: SELECT xet.event_id event_id
75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75559: SELECT xet.event_id event_id
75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null
75582: END object_name
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null
75582: END object_name
75583: , CASE r
75680:
75681: ELSE null
75682: END source_meaning
75683: FROM xla_events_gt xet
75684: , PA_XLA_CCDL_LINES_V l1
75685: , fnd_lookup_values fvl35
75686: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
75687: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75688: AND xet.event_class_code = C_EVENT_CLASS_CODE
75825: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;
75849: l_array_source_73 t_array_source_73;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;
75849: l_array_source_73 t_array_source_73;
75850: l_array_source_73_meaning t_array_lookup_meaning;
75967: , l1.LINE_NUM_REVERSED source_36
75968: , l1.ENTERED_AMOUNT source_42
75969: , l1.ACCT_AMOUNT source_43
75970: FROM xla_events_gt xet
75971: , PA_XLA_CCDL_LINES_V l1
75972: , fnd_lookup_values fvl35
75973: WHERE xet.event_id between x_first_event_id and x_last_event_id
75974: and xet.event_date between p_pad_start_date and p_pad_end_date
75975: and xet.event_class_code = C_EVENT_CLASS_CODE
89655: FROM (
89656: SELECT xet.event_id event_id
89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89656: SELECT xet.event_id event_id
89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null
89679: END object_name
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null
89679: END object_name
89680: , CASE r
89777:
89778: ELSE null
89779: END source_meaning
89780: FROM xla_events_gt xet
89781: , PA_XLA_CCDL_LINES_V l1
89782: , fnd_lookup_values fvl35
89783: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
89784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89785: AND xet.event_class_code = C_EVENT_CLASS_CODE
89921:
89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;
89945: l_array_source_75 t_array_source_75;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;
89945: l_array_source_75 t_array_source_75;
89946:
90054: , l1.LINE_NUM_REVERSED source_36
90055: , l1.ENTERED_AMOUNT source_42
90056: , l1.ACCT_AMOUNT source_43
90057: FROM xla_events_gt xet
90058: , PA_XLA_CCDL_LINES_V l1
90059: , fnd_lookup_values fvl35
90060: WHERE xet.event_id between x_first_event_id and x_last_event_id
90061: and xet.event_date between p_pad_start_date and p_pad_end_date
90062: and xet.event_class_code = C_EVENT_CLASS_CODE
90953: FROM (
90954: SELECT xet.event_id event_id
90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90954: SELECT xet.event_id event_id
90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null
90977: END object_name
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null
90977: END object_name
90978: , CASE r
91075:
91076: ELSE null
91077: END source_meaning
91078: FROM xla_events_gt xet
91079: , PA_XLA_CCDL_LINES_V l1
91080: , fnd_lookup_values fvl35
91081: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
91082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
91083: AND xet.event_class_code = C_EVENT_CLASS_CODE
91219:
91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;
91243: l_array_source_75 t_array_source_75;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;
91243: l_array_source_75 t_array_source_75;
91244:
91352: , l1.LINE_NUM_REVERSED source_36
91353: , l1.ENTERED_AMOUNT source_42
91354: , l1.ACCT_AMOUNT source_43
91355: FROM xla_events_gt xet
91356: , PA_XLA_CCDL_LINES_V l1
91357: , fnd_lookup_values fvl35
91358: WHERE xet.event_id between x_first_event_id and x_last_event_id
91359: and xet.event_date between p_pad_start_date and p_pad_end_date
91360: and xet.event_class_code = C_EVENT_CLASS_CODE