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_000015_PKG dependencies on PA_XLA_CCDL_LINES_V

Line 74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

74150: FROM (
74151: SELECT xet.event_id event_id
74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

74151: SELECT xet.event_id event_id
74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

74152: , l1.line_number line_number
74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

74153: , CASE r
74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

74154: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

74155: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

74156: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

74157: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

74158: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

74159: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

74160: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

74161: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

74162: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

74163: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

74164: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:

Line 74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

74165: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null

Line 74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

74166: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null
74174: END object_name

Line 74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

74167: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
74168: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
74169: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
74170: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
74171: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
74172:
74173: ELSE null
74174: END object_name
74175: , CASE r

Line 74276: , PA_XLA_CCDL_LINES_V l1

74272:
74273: ELSE null
74274: END source_meaning
74275: FROM xla_events_gt xet
74276: , PA_XLA_CCDL_LINES_V l1
74277: , fnd_lookup_values fvl35
74278: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
74279: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74280: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

74417: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

74418: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

74419: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

74420:
74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

74421: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

74422: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

74423: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

74424: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

74425: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

74426: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

74427: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

74428: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

74429: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

74430: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

74431: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:

Line 74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

74432: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;

Line 74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

74433: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;
74441: l_array_source_73 t_array_source_73;

Line 74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

74434: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
74435: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
74436: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
74437: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74438: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
74439:
74440: l_array_source_33 t_array_source_33;
74441: l_array_source_73 t_array_source_73;
74442: l_array_source_73_meaning t_array_lookup_meaning;

Line 74563: , PA_XLA_CCDL_LINES_V l1

74559: , l1.LINE_NUM_REVERSED source_36
74560: , l1.ENTERED_AMOUNT source_42
74561: , l1.ACCT_AMOUNT source_43
74562: FROM xla_events_gt xet
74563: , PA_XLA_CCDL_LINES_V l1
74564: , fnd_lookup_values fvl35
74565: WHERE xet.event_id between x_first_event_id and x_last_event_id
74566: and xet.event_date between p_pad_start_date and p_pad_end_date
74567: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

75558: FROM (
75559: SELECT xet.event_id event_id
75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

75559: SELECT xet.event_id event_id
75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

75560: , l1.line_number line_number
75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

75561: , CASE r
75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

75562: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

75563: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

75564: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

75565: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

75566: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

75567: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

75568: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

75569: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

75570: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

75571: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

75572: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:

Line 75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

75573: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null

Line 75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

75574: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null
75582: END object_name

Line 75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

75575: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
75576: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
75577: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
75578: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
75579: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
75580:
75581: ELSE null
75582: END object_name
75583: , CASE r

Line 75684: , PA_XLA_CCDL_LINES_V l1

75680:
75681: ELSE null
75682: END source_meaning
75683: FROM xla_events_gt xet
75684: , PA_XLA_CCDL_LINES_V l1
75685: , fnd_lookup_values fvl35
75686: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
75687: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75688: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

75825: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

75826: TYPE t_array_source_73 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

75827: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

75828:
75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

75829: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

75830: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

75831: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

75832: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

75833: TYPE t_array_source_16 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

75834: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

75835: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

75836: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

75837: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

75838: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

75839: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:

Line 75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

75840: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;

Line 75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

75841: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;
75849: l_array_source_73 t_array_source_73;

Line 75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

75842: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
75843: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75844: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
75845: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75846: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
75847:
75848: l_array_source_33 t_array_source_33;
75849: l_array_source_73 t_array_source_73;
75850: l_array_source_73_meaning t_array_lookup_meaning;

Line 75971: , PA_XLA_CCDL_LINES_V l1

75967: , l1.LINE_NUM_REVERSED source_36
75968: , l1.ENTERED_AMOUNT source_42
75969: , l1.ACCT_AMOUNT source_43
75970: FROM xla_events_gt xet
75971: , PA_XLA_CCDL_LINES_V l1
75972: , fnd_lookup_values fvl35
75973: WHERE xet.event_id between x_first_event_id and x_last_event_id
75974: and xet.event_date between p_pad_start_date and p_pad_end_date
75975: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

89655: FROM (
89656: SELECT xet.event_id event_id
89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

89656: SELECT xet.event_id event_id
89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

89657: , l1.line_number line_number
89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

89658: , CASE r
89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

89659: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

89660: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

89661: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

89662: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

89663: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

89664: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

89665: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

89666: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

89667: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

89668: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

89669: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:

Line 89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

89670: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null

Line 89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

89671: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null
89679: END object_name

Line 89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

89672: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
89673: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
89674: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
89675: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
89676: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
89677:
89678: ELSE null
89679: END object_name
89680: , CASE r

Line 89781: , PA_XLA_CCDL_LINES_V l1

89777:
89778: ELSE null
89779: END source_meaning
89780: FROM xla_events_gt xet
89781: , PA_XLA_CCDL_LINES_V l1
89782: , fnd_lookup_values fvl35
89783: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
89784: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
89785: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

89921:
89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

89922: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

89923: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

89924:
89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

89925: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

89926: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

89927: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

89928: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

89929: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

89930: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

89931: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

89932: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

89933: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

89934: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

89935: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:

Line 89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

89936: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;

Line 89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

89937: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;
89945: l_array_source_75 t_array_source_75;

Line 89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

89938: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
89939: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
89940: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
89941: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89942: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
89943:
89944: l_array_source_33 t_array_source_33;
89945: l_array_source_75 t_array_source_75;
89946:

Line 90058: , PA_XLA_CCDL_LINES_V l1

90054: , l1.LINE_NUM_REVERSED source_36
90055: , l1.ENTERED_AMOUNT source_42
90056: , l1.ACCT_AMOUNT source_43
90057: FROM xla_events_gt xet
90058: , PA_XLA_CCDL_LINES_V l1
90059: , fnd_lookup_values fvl35
90060: WHERE xet.event_id between x_first_event_id and x_last_event_id
90061: and xet.event_date between p_pad_start_date and p_pad_end_date
90062: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

90953: FROM (
90954: SELECT xet.event_id event_id
90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

90954: SELECT xet.event_id event_id
90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

90955: , l1.line_number line_number
90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

90956: , CASE r
90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

90957: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

90958: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

90959: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

90960: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

90961: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

90962: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

90963: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

90964: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

90965: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

90966: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

90967: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:

Line 90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

90968: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null

Line 90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

90969: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null
90977: END object_name

Line 90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

90970: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
90971: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
90972: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
90973: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
90974: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
90975:
90976: ELSE null
90977: END object_name
90978: , CASE r

Line 91079: , PA_XLA_CCDL_LINES_V l1

91075:
91076: ELSE null
91077: END source_meaning
91078: FROM xla_events_gt xet
91079: , PA_XLA_CCDL_LINES_V l1
91080: , fnd_lookup_values fvl35
91081: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
91082: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
91083: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

91219:
91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

91220: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

91221: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

91222:
91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

91223: TYPE t_array_source_5 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

91224: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

91225: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

91226: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

91227: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

91228: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

91229: TYPE t_array_source_24 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

91230: TYPE t_array_source_26 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

91231: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

91232: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

91233: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:

Line 91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

91234: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;

Line 91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

91235: TYPE t_array_source_32 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;
91243: l_array_source_75 t_array_source_75;

Line 91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

91236: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
91237: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
91238: TYPE t_array_source_36 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
91239: TYPE t_array_source_42 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91240: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
91241:
91242: l_array_source_33 t_array_source_33;
91243: l_array_source_75 t_array_source_75;
91244:

Line 91356: , PA_XLA_CCDL_LINES_V l1

91352: , l1.LINE_NUM_REVERSED source_36
91353: , l1.ENTERED_AMOUNT source_42
91354: , l1.ACCT_AMOUNT source_43
91355: FROM xla_events_gt xet
91356: , PA_XLA_CCDL_LINES_V l1
91357: , fnd_lookup_values fvl35
91358: WHERE xet.event_id between x_first_event_id and x_last_event_id
91359: and xet.event_date between p_pad_start_date and p_pad_end_date
91360: and xet.event_class_code = C_EVENT_CLASS_CODE