55465: FROM (
55466: SELECT xet.event_id event_id
55467: , l1.line_number line_number
55468: , CASE r
55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55466: SELECT xet.event_id event_id
55467: , l1.line_number line_number
55468: , CASE r
55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55467: , l1.line_number line_number
55468: , CASE r
55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55468: , CASE r
55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55470: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55471: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55472: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55473: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55474: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55475: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55476: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55477: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55478: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55486: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55479: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55486: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55487:
55480: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55486: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55487:
55488: ELSE null
55481: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55486: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55487:
55488: ELSE null
55489: END object_name
55482: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55483: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55484: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55485: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55486: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55487:
55488: ELSE null
55489: END object_name
55490: , CASE r
55587:
55588: ELSE null
55589: END source_meaning
55590: FROM xla_events_gt xet
55591: , PA_XLA_CCDL_LINES_V l1
55592: , fnd_lookup_values fvl34
55593: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55595: AND xet.event_class_code = C_EVENT_CLASS_CODE
55732: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55733: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55734: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55735:
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55754:
55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55754:
55755: l_array_source_32 t_array_source_32;
55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55754:
55755: l_array_source_32 t_array_source_32;
55756: l_array_source_67 t_array_source_67;
55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55754:
55755: l_array_source_32 t_array_source_32;
55756: l_array_source_67 t_array_source_67;
55757: l_array_source_67_meaning t_array_lookup_meaning;
55874: , l1.LINE_NUM_REVERSED source_35
55875: , l1.ENTERED_AMOUNT source_41
55876: , l1.ACCT_AMOUNT source_43
55877: FROM xla_events_gt xet
55878: , PA_XLA_CCDL_LINES_V l1
55879: , fnd_lookup_values fvl34
55880: WHERE xet.event_id between x_first_event_id and x_last_event_id
55881: and xet.event_date between p_pad_start_date and p_pad_end_date
55882: and xet.event_class_code = C_EVENT_CLASS_CODE
56873: FROM (
56874: SELECT xet.event_id event_id
56875: , l1.line_number line_number
56876: , CASE r
56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56874: SELECT xet.event_id event_id
56875: , l1.line_number line_number
56876: , CASE r
56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56875: , l1.line_number line_number
56876: , CASE r
56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56876: , CASE r
56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56878: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56879: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56880: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56881: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56882: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56883: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56884: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56885: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56886: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56894: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56887: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56894: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56895:
56888: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56894: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56895:
56896: ELSE null
56889: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56894: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56895:
56896: ELSE null
56897: END object_name
56890: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56891: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56892: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56893: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56894: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56895:
56896: ELSE null
56897: END object_name
56898: , CASE r
56995:
56996: ELSE null
56997: END source_meaning
56998: FROM xla_events_gt xet
56999: , PA_XLA_CCDL_LINES_V l1
57000: , fnd_lookup_values fvl34
57001: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
57002: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57003: AND xet.event_class_code = C_EVENT_CLASS_CODE
57140: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57141: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57142: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57143:
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57162:
57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57162:
57163: l_array_source_32 t_array_source_32;
57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57162:
57163: l_array_source_32 t_array_source_32;
57164: l_array_source_67 t_array_source_67;
57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57162:
57163: l_array_source_32 t_array_source_32;
57164: l_array_source_67 t_array_source_67;
57165: l_array_source_67_meaning t_array_lookup_meaning;
57282: , l1.LINE_NUM_REVERSED source_35
57283: , l1.ENTERED_AMOUNT source_41
57284: , l1.ACCT_AMOUNT source_43
57285: FROM xla_events_gt xet
57286: , PA_XLA_CCDL_LINES_V l1
57287: , fnd_lookup_values fvl34
57288: WHERE xet.event_id between x_first_event_id and x_last_event_id
57289: and xet.event_date between p_pad_start_date and p_pad_end_date
57290: and xet.event_class_code = C_EVENT_CLASS_CODE
70684: FROM (
70685: SELECT xet.event_id event_id
70686: , l1.line_number line_number
70687: , CASE r
70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70685: SELECT xet.event_id event_id
70686: , l1.line_number line_number
70687: , CASE r
70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70686: , l1.line_number line_number
70687: , CASE r
70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70687: , CASE r
70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70689: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70690: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70691: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70692: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70693: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70694: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70695: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70696: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70697: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70705: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70698: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70705: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70706:
70699: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70705: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70706:
70707: ELSE null
70700: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70705: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70706:
70707: ELSE null
70708: END object_name
70701: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70702: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70703: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70704: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70705: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70706:
70707: ELSE null
70708: END object_name
70709: , CASE r
70806:
70807: ELSE null
70808: END source_meaning
70809: FROM xla_events_gt xet
70810: , PA_XLA_CCDL_LINES_V l1
70811: , fnd_lookup_values fvl34
70812: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70814: AND xet.event_class_code = C_EVENT_CLASS_CODE
70950:
70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70951: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70952: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70953:
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70972:
70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70972:
70973: l_array_source_32 t_array_source_32;
70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70972:
70973: l_array_source_32 t_array_source_32;
70974: l_array_source_88 t_array_source_88;
70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70972:
70973: l_array_source_32 t_array_source_32;
70974: l_array_source_88 t_array_source_88;
70975:
71083: , l1.LINE_NUM_REVERSED source_35
71084: , l1.ENTERED_AMOUNT source_41
71085: , l1.ACCT_AMOUNT source_43
71086: FROM xla_events_gt xet
71087: , PA_XLA_CCDL_LINES_V l1
71088: , fnd_lookup_values fvl34
71089: WHERE xet.event_id between x_first_event_id and x_last_event_id
71090: and xet.event_date between p_pad_start_date and p_pad_end_date
71091: and xet.event_class_code = C_EVENT_CLASS_CODE
71982: FROM (
71983: SELECT xet.event_id event_id
71984: , l1.line_number line_number
71985: , CASE r
71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71983: SELECT xet.event_id event_id
71984: , l1.line_number line_number
71985: , CASE r
71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71984: , l1.line_number line_number
71985: , CASE r
71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71985: , CASE r
71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71987: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71988: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71989: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71990: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71991: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71992: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71993: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71994: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71995: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
72003: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
71996: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
72003: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
72004:
71997: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
72003: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
72004:
72005: ELSE null
71998: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
72003: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
72004:
72005: ELSE null
72006: END object_name
71999: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
72000: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
72001: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
72002: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
72003: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
72004:
72005: ELSE null
72006: END object_name
72007: , CASE r
72104:
72105: ELSE null
72106: END source_meaning
72107: FROM xla_events_gt xet
72108: , PA_XLA_CCDL_LINES_V l1
72109: , fnd_lookup_values fvl34
72110: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72111: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72112: AND xet.event_class_code = C_EVENT_CLASS_CODE
72248:
72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72249: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72250: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72251:
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72270:
72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72270:
72271: l_array_source_32 t_array_source_32;
72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72270:
72271: l_array_source_32 t_array_source_32;
72272: l_array_source_88 t_array_source_88;
72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72270:
72271: l_array_source_32 t_array_source_32;
72272: l_array_source_88 t_array_source_88;
72273:
72381: , l1.LINE_NUM_REVERSED source_35
72382: , l1.ENTERED_AMOUNT source_41
72383: , l1.ACCT_AMOUNT source_43
72384: FROM xla_events_gt xet
72385: , PA_XLA_CCDL_LINES_V l1
72386: , fnd_lookup_values fvl34
72387: WHERE xet.event_id between x_first_event_id and x_last_event_id
72388: and xet.event_date between p_pad_start_date and p_pad_end_date
72389: and xet.event_class_code = C_EVENT_CLASS_CODE