DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_REVENUE_LINES_ADJ_V

Line 73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73304: FROM (
73305: SELECT xet.event_id event_id
73306: , l3.line_number line_number
73307: , CASE r
73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73305: SELECT xet.event_id event_id
73306: , l3.line_number line_number
73307: , CASE r
73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73306: , l3.line_number line_number
73307: , CASE r
73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73307: , CASE r
73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73308: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73309: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73310: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73311: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73312: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73313: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73314: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'

Line 73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73315: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73316: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73317: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73318: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73319: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73320: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73321: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73322: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73323: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73331:

Line 73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73324: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73331:
73332: ELSE null

Line 73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73325: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73331:
73332: ELSE null
73333: END object_name

Line 73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73326: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73327: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73328: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73329: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73330: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73331:
73332: ELSE null
73333: END object_name
73334: , CASE r

Line 73450: , PA_XLA_REVENUE_LINES_ADJ_V l3

73446: ELSE null
73447: END source_meaning
73448: FROM xla_events_gt xet
73449: , PA_XLA_EVENT_TYPE_REF_V l1
73450: , PA_XLA_REVENUE_LINES_ADJ_V l3
73451: , fnd_lookup_values fvl58
73452: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73453: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73454: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

73593: TYPE t_array_source_88 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

73594: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

73595: TYPE t_array_source_93 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

73596:
73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

73597: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

73598: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

73599: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

73600: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

73601: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73602: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73603: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

Line 73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73604: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

73605: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

73606: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73607: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

73608: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

73609: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

73610: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

73611: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

Line 73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73612: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73620:

Line 73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

73613: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73620:
73621: l_array_source_38 t_array_source_38;

Line 73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73614: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73620:
73621: l_array_source_38 t_array_source_38;
73622: l_array_source_42 t_array_source_42;

Line 73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

73615: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73616: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73617: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73618: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73619: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73620:
73621: l_array_source_38 t_array_source_38;
73622: l_array_source_42 t_array_source_42;
73623: l_array_source_88 t_array_source_88;

Line 73752: , PA_XLA_REVENUE_LINES_ADJ_V l3

73748: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73749: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73750: FROM xla_events_gt xet
73751: , PA_XLA_EVENT_TYPE_REF_V l1
73752: , PA_XLA_REVENUE_LINES_ADJ_V l3
73753: , fnd_lookup_values fvl58
73754: WHERE xet.event_id between x_first_event_id and x_last_event_id
73755: and xet.event_date between p_pad_start_date and p_pad_end_date
73756: and xet.event_class_code = C_EVENT_CLASS_CODE