eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_CCDL_LINES_V

Line 55469: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

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'

Line 55470: WHEN 2 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'

Line 55471: WHEN 3 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'

Line 55472: WHEN 4 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'

Line 55473: WHEN 5 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'

Line 55474: WHEN 6 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'

Line 55475: WHEN 7 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'

Line 55476: WHEN 8 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'

Line 55477: WHEN 9 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'

Line 55478: WHEN 10 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'

Line 55479: WHEN 11 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'

Line 55480: WHEN 12 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'

Line 55481: WHEN 13 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'

Line 55482: WHEN 14 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'

Line 55483: WHEN 15 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:

Line 55484: WHEN 16 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:
55488: ELSE null

Line 55485: WHEN 17 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
55489: END object_name

Line 55486: WHEN 18 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
55490: , CASE r

Line 55591: , PA_XLA_CCDL_LINES_V l1

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

Line 55736: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;

Line 55737: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_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;

Line 55738: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%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;

Line 55739: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%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;

Line 55740: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%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;

Line 55741: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_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;
55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 55742: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%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;

Line 55743: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 55744: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%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;

Line 55745: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%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;

Line 55746: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 55747: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_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;
55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 55748: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%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;

Line 55749: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%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;

Line 55750: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%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:

Line 55751: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%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:
55755: l_array_source_32 t_array_source_32;

Line 55752: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%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;
55756: l_array_source_67 t_array_source_67;

Line 55753: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%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;
55757: l_array_source_67_meaning t_array_lookup_meaning;

Line 55878: , PA_XLA_CCDL_LINES_V l1

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

Line 56877: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

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'

Line 56878: WHEN 2 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'

Line 56879: WHEN 3 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'

Line 56880: WHEN 4 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'

Line 56881: WHEN 5 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'

Line 56882: WHEN 6 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'

Line 56883: WHEN 7 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'

Line 56884: WHEN 8 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'

Line 56885: WHEN 9 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'

Line 56886: WHEN 10 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'

Line 56887: WHEN 11 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'

Line 56888: WHEN 12 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'

Line 56889: WHEN 13 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'

Line 56890: WHEN 14 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'

Line 56891: WHEN 15 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:

Line 56892: WHEN 16 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:
56896: ELSE null

Line 56893: WHEN 17 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
56897: END object_name

Line 56894: WHEN 18 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
56898: , CASE r

Line 56999: , PA_XLA_CCDL_LINES_V l1

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

Line 57144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;

Line 57145: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_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;

Line 57146: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%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;

Line 57147: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%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;

Line 57148: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%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;

Line 57149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_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;
57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 57150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%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;

Line 57151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 57152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%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;

Line 57153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%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;

Line 57154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 57155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_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;
57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 57156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%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;

Line 57157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%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;

Line 57158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%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:

Line 57159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%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:
57163: l_array_source_32 t_array_source_32;

Line 57160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%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;
57164: l_array_source_67 t_array_source_67;

Line 57161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%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;
57165: l_array_source_67_meaning t_array_lookup_meaning;

Line 57286: , PA_XLA_CCDL_LINES_V l1

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

Line 70688: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

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'

Line 70689: WHEN 2 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'

Line 70690: WHEN 3 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'

Line 70691: WHEN 4 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'

Line 70692: WHEN 5 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'

Line 70693: WHEN 6 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'

Line 70694: WHEN 7 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'

Line 70695: WHEN 8 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'

Line 70696: WHEN 9 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'

Line 70697: WHEN 10 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'

Line 70698: WHEN 11 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'

Line 70699: WHEN 12 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'

Line 70700: WHEN 13 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'

Line 70701: WHEN 14 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'

Line 70702: WHEN 15 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:

Line 70703: WHEN 16 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:
70707: ELSE null

Line 70704: WHEN 17 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
70708: END object_name

Line 70705: WHEN 18 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
70709: , CASE r

Line 70810: , PA_XLA_CCDL_LINES_V l1

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

Line 70954: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;

Line 70955: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_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;

Line 70956: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%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;

Line 70957: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%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;

Line 70958: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%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;

Line 70959: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_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;
70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 70960: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%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;

Line 70961: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 70962: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%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;

Line 70963: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%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;

Line 70964: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 70965: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_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;
70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 70966: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%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;

Line 70967: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%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;

Line 70968: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%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:

Line 70969: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%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:
70973: l_array_source_32 t_array_source_32;

Line 70970: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%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;
70974: l_array_source_88 t_array_source_88;

Line 70971: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%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;
70975:

Line 71087: , PA_XLA_CCDL_LINES_V l1

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

Line 71986: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

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'

Line 71987: WHEN 2 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'

Line 71988: WHEN 3 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'

Line 71989: WHEN 4 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'

Line 71990: WHEN 5 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'

Line 71991: WHEN 6 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'

Line 71992: WHEN 7 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'

Line 71993: WHEN 8 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'

Line 71994: WHEN 9 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'

Line 71995: WHEN 10 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'

Line 71996: WHEN 11 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'

Line 71997: WHEN 12 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'

Line 71998: WHEN 13 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'

Line 71999: WHEN 14 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'

Line 72000: WHEN 15 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:

Line 72001: WHEN 16 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:
72005: ELSE null

Line 72002: WHEN 17 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
72006: END object_name

Line 72003: WHEN 18 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
72007: , CASE r

Line 72108: , PA_XLA_CCDL_LINES_V l1

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

Line 72252: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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;

Line 72253: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_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;

Line 72254: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%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;

Line 72255: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%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;

Line 72256: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%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;

Line 72257: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_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;
72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 72258: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%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;

Line 72259: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 72260: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%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;

Line 72261: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%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;

Line 72262: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 72263: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_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;
72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 72264: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%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;

Line 72265: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%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;

Line 72266: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%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:

Line 72267: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%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:
72271: l_array_source_32 t_array_source_32;

Line 72268: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%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;
72272: l_array_source_88 t_array_source_88;

Line 72269: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%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;
72273:

Line 72385: , PA_XLA_CCDL_LINES_V l1

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